|Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)
Part Number E17126-03
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
FOR statement. You need not close a cursor variable before reopening it.
The name of an open explicit cursor.
The name of an open cursor variable.
The name of a cursor variable declared in a PL/SQL host environment and passed to PL/SQL as a bind argument. Do not put space between the colon (:) and
The data type of a host cursor variable is compatible with the return type of any PL/SQL cursor variable.
In this chapter:
In other chapters: