VARIABLE_VALUE_BLOB procedure - Return the value of a BLOB INOUT or OUT parameter

The VARIABLE_VALUE_BLOB procedure provides the capability to return the value of a BLOB INOUT or OUT parameter.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.VARIABLE_VALUE_BLOB( 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 BLOB(2G) that specifies the variable receiving the value.

Authorization

EXECUTE privilege on the DBMS_SQL module.