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

CLOSE example

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

close movie_cursor;
commit;