CLOSE_CURSOR procedure - Close a cursor

The CLOSE_CURSOR procedure closes an open cursor. The resources allocated to the cursor are released and it cannot no longer be used.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.CLOSE_CURSOR( c)

Parameters

c
An input argument of type INTEGER that specifies the cursor ID of the cursor to be closed.

Authorization

EXECUTE privilege on the DBMS_SQL module.

Examples

Example 1: This example illustrates closing a previously opened cursor.
DECLARE
    curid           INTEGER;
BEGIN
    curid := DBMS_SQL.OPEN_CURSOR;
            .
            .
            .
    DBMS_SQL.CLOSE_CURSOR(curid);
END;