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
FOR statement. You need not close a cursor variable before reopening it.
Name of an open explicit cursor.
Name of an open 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
Example 6-6, "FETCH Statements Inside LOOP Statements"