The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed cursor.
Keyword and Parameter Description
These identify an explicit cursor previously declared within the present scope and presently open.
These identify the PL/SQL cursor variable previously declared within the present scope and presently open.
These identify a cursor variable declared in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable. The host cursor variable datatype is well-suited with the return type of any PL/SQL cursor variable. The host variables should be prefixed with a colon.