DB2 Version 9.7 for Linux, UNIX, and Windows

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


>>-DBMS_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;