Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
The CLOSE
statement closes a named cursor, freeing its resources for reuse.
After closing an explicit cursor, you can reopen it with the OPEN
statement. You must close an explicit 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.
LNPLS1084Topics
LNPLS987close_statement ::=
LNPLS988cursor
Name of an open explicit cursor.
LNPLS989cursor_variable
Name of an open cursor variable.
LNPLS1085:host_cursor_variable
Name of a cursor variable declared in a PL/SQL host environment and passed to PL/SQL as a bind variable. Do not put space between the colon (:) and host_cursor_variable
.
LNPLS1086In this chapter:
LNPLS1089In other chapters: