59.7 GET_VARIABLE_CLOB_VALUE Function

This function gets the CLOB value of a workflow variable.

Returns the VARCHAR2 value if the data type of the variable is VARCHAR2. 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

Parameter	Description
p_instance_id	ID of the Workflow.
p_variable_static_id	Static ID of the variable.

Returns

CLOB

Example

The following example returns the value of Workflow Variable called REST_RESPONSE.

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