December 2002
Intermediate to advanced
928 pages
85h 29m
English
CLOSE cursor_name;Closes an explicit cursor. After all rows have been fetched, a cursor needs to be closed. Closing a cursor enables the PL/SQL memory optimization algorithm to release the associated memory at an appropriate time.
If you declare a cursor in a local anonymous, procedure, or function block, that cursor will automatically close when the block terminates. Cursors that are declared in a package must be closed explicitly, or they stay open for the duration of your session. Closing a cursor that is not open raises an INVALID CURSOR exception.
Name of the cursor declared and opened.