Support for CLOB and BLOB variables in Workpoint SQL Nodes added in version 7.0.1 with the new Workflow Editor in RSA Identity Governance & Lifecycle

[#1]

Article Number

000039253

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.1, 7.0.2, 7.1.x, 7.2.x
 

Issue

CLOB and BLOB variable support for use in Workpoint SQL Nodes is now available starting in version 7.0.1 of RSA Identity Governance & Lifecycle with the new Workflow Editor.
 

Resolution

The following datatypes and functions are supported for use in Workpoint SQL Select and SQL Execute Nodes.

• CLOB datatype
• BLOB datatype
• getClob()
• getClobVal()
• getBlob()
• getBlob(Val)

EXAMPLES:

Example 1: Here is an example of selecting a CLOB datatype in a workflow SQL Select node:

select id, name, type, form_data from acmdb.change_request where id=1

• Public view acmdb.change_request has column form_data which is a CLOB datatype.
• Go to Requests > Workflows > Request tab > {Workflow name} > Add a SQL Select node > Enter SQL Query > Save.
• Create a Request that uses this Workflow. Note that it completes without error.

Example 2: Here is an example of using function getClobval() on an XMLTYPE datatype in a workflow SQL Select node:

select id, name, type, cr.violations.getClobval() as VIOL from acmdb.change_request cr where id=1

• Public view acmdb.change_request has column violations which is an XMLTYPE datatype.
• Go to Requests > Workflows > Request tab > {Workflow name} > Add a SQL Select node > Enter SQL Query > Save.
• Create a Request that uses this Workflow. Note that it completes without error.

 

Notes

See related RSA Knowledge Base Article 000031834 -- java.sql.SQLException: Unsupported feature when executing a Workflow with a SQL Node in RSA Identity Governance & Lifecycle for more information.