IS_OPEN

The IS_OPEN function checks whether the specified cursor is in the OPEN state.

Syntax

DBMS_SQL.IS_OPEN (
   c              IN INTEGER)
  RETURN BOOLEAN;

Parameters

Return value

TRUE is returned if the cursor is open but not closed, and FALSE is returned if the cursor ID is NULL. Note that the CLOSE_CURSOR stored procedure sets the cursor variable passed to it to NULL.

Exceptions

OBE-29471: Access to DBMS_SQL is denied. This error is raised when an invalid cursor ID is detected. Once a session encounters and reports this error, subsequent calls to DBMS_SQL from the same session will also raise this error.