IS_OPEN function - Check whether a cursor is open
The IS_OPEN function tests whether a specified cursor is open.
Syntax
Parameters
- c
- An input argument of type INTEGER that specifies the ID of the cursor to be tested.
- ret
- An output argument of type BOOLEAN that returns a value of TRUE if the specified cursor is open and FALSE if the cursor is closed.
Authorization
EXECUTE privilege on the DBMS_SQL module.
Usage notes
You can call this function with the function invocation syntax in a PL/SQL assignment statement.
Examples
In the following example, the DBMS_SQL.IS_OPEN
function is called to determine whether the cursor that is specified
in the cur argument is open:
DECLARE rc boolean;
SET rc = DBMS_SQL.IS_OPEN(cur);