DEFINE_COLUMN_CLOB - Define a CLOB column in the SELECT list

The DEFINE_COLUMN_CLOB procedure defines a CLOB column or expression in the SELECT list that is to be returned and retrieved in a cursor.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.DEFINE_COLUMN_CLOB( c,position,column )

Parameters

c
An input argument of type INTEGER that specifies the cursor handle associated with the SELECT command.
position
An input argument of type INTEGER that specifies the position of the column or expression in the SELECT list that is being defined.
column
An input argument of type CLOB(2G).

Authorization

EXECUTE privilege on the DBMS_SQL module.