CLOSE

(Optional) Closes all of the free resources that are associated with an open cursor. COMMIT, END, and ROLLBACK automatically close the cursor, so it isn't necessary to use the CLOSE command to explicitly close the cursor.

For more information, see DECLARE, FETCH.

Syntax

CLOSE cursor

Parameters

cursor

Name of the cursor to close.

CLOSE example

The following commands close the cursor and perform a commit, which ends the transaction:

close movie_cursor;
commit;