IS_OPEN procedure - Check whether a cursor is open

The IS_OPEN procedure tests whether a specified cursor is open.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.IS_OPEN(c, ret)

Parameters

c
An input argument of type INTEGER that specifies the ID of the cursor to be tested.
ret
An output argument of type INTEGER that returns a value of 1 if the specified cursor is open and 0 if the cursor is closed.

Authorization

EXECUTE privilege on the DBMS_SQL module.

Examples

In the following example, the DBMS_SQL.IS_OPEN procedure is called to determine whether the cursor that is specified in the cur argument is open:
DECLARE rc integer;

CALL DBMS_SQL.IS_OPEN(cur, rc);