This function gets the CLOB value of a workflow variable. It returns the VARCHAR2 value if the data type of the variable is VARCHAR2. It returns NULL if the variable is not of CLOB or VARCHAR2 datatype.

Syntax

APEX_WORKFLOW.GET_VARIABLE_CLOB_VALUE (
    p_instance_id            IN NUMBER,
    p_variable_static_id     IN VARCHAR2 )
RETURN CLOB;

Parameters

Returns

CLOB

Example

The following example returns the value of the Workflow variable called "REST_RESPONSE."

BEGIN
    apex_workflow.get_variable_clob_value(
           p_instance_id => 1234,
           p_variable_static_id => 'REST_RESPONSE');
END;