The CLOSE
statement closes a cursor or cursor variable, thereby allowing its resources to be reused.
After closing a cursor, you can reopen it with the OPEN
statement. You must close a cursor before reopening it.
After closing a cursor variable, you can reopen it with the OPEN-FOR
statement. You need not close a cursor variable before reopening it.
Keyword and Parameter Descriptions
The name of an open explicit cursor that was declared within the current scope.
The name of an open cursor variable that was declared in the current scope.
The name of an open cursor variable that was declared in a PL/SQL host environment and passed to PL/SQL as a bind argument.