• 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.