VARIABLE_VALUE_CLOB procedure - Return the value of a CLOB INOUT or OUT parameter

The VARIABLE_VALUE_CLOB procedure provides the capability to return the value of a CLOB INOUT or OUT parameter.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.VARIABLE_VALUE_CLOB( c,name,value )

Parameters

c
An input argument of type INTEGER that specifies the cursor ID of the cursor returning a bind variable.
name
An input argument that specifies the name of the bind variable.
value
An output argument of type CLOB(2G) that specifies the variable receiving the value.

Authorization

EXECUTE privilege on the DBMS_SQL module.