Close Statement
This statement closes an open cursor.
This statement has the following syntax:
close cursor_variable;
The close statement closes a cursor and sets the State attribute of the CursorObject to CS_CLOSED. When the cursor is closed, you cannot use it for further processing unless you reopen it with a new
open statement (see
Open Statement). To use the close statement, you must have previously opened the specified cursor object with an open statement.
The commit and rollback statements implicitly close all open cursors. For more information about using cursors, see the Programming Guide.