COLUMN_VALUE_LONG procedure - Return a LONG column value into a variable

The COLUMN_VALUE_LONG procedure defines a variable that will receive a portion of a LONG value from a cursor.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.COLUMN_VALUE_LONG( c,position,length ,offset,value,value_length )

Parameters

c
An input argument of type INTEGER that specifies the cursor ID of the cursor that is returning data to the variable being defined.
position
An input argument of type INTEGER that specifies the position of the returned data within the cursor. The first value in the cursor is position 1.
length
An input argument of type INTEGER that specifies the desired number of bytes of the LONG data to retrieve beginning at offset.
offset
An input argument of type INTEGER that specifies the position within the LONG value to start data retrieval.
value
An output argument of type CLOB(32760) that specifies the variable receiving the data returned by the cursor in a prior fetch call.
value_length
An output argument of type INTEGER that returns the actual length of the data returned.

Authorization

EXECUTE privilege on the DBMS_SQL module.