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;