The IS_OPEN function checks whether a specified cursor is in the OPEN state.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SQL.IS_OPEN (
c IN INTEGER)
RETURN BOOLEAN;
Parameters
| Parameter | Description |
|---|---|
| c | The ID of the cursor to be checked. |
Return values
If the cursor is open, this function returns TRUE. If the cursor ID is NULL, this function returns FALSE. The CLOSE_CURSOR stored procedure sets the received cursor variable to NULL.
Exceptions
ORA-29471: DBMS_SQL access is denied. This exception is thrown when an invalid cursor ID is detected. If a session encounters this exception, this exception will be thrown for all subsequent DBMS_SQL calls in the same session.