TO_CURSOR_NUMBER

The TO_CURSOR_NUMBER function converts an open REF CURSOR into a DBMS_SQL cursor ID and returns that cursor ID. After conversion, you can use the relevant subprograms of DBMS_SQL to operate on the cursor.

Syntax

DBMS_SQL.TO_CURSOR_NUMBER(rc IN OUT SYS_REFCURSOR) RETURN INTEGER

Parameters

Return value

Returns the ID of the converted DBMS_SQL cursor (INTEGER type).

Usage instructions

• The passed-in REF CURSOR must be a valid and open cursor; otherwise, a INVALID_CURSOR error is raised.
• After the conversion is complete, you can use the subprograms of DBMS_SQL to perform further operations on this cursor.