CLOSE Statement

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.

Syntax

close_statement ::=

Description of the illustration close_statement.gif

Keyword and Parameter Descriptions

cursor_name

The name of an open explicit cursor that was declared within the current scope.

cursor_variable_name

The name of an open cursor variable that was declared in the current scope.

host_cursor_variable_name

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.

Examples

• Example 4-24, "EXIT in a FOR LOOP"

• Example 6-10, "Fetching with a Cursor"

• Example 6-13, "Fetching Bulk Data with a Cursor"

Related Topics

• FETCH Statement

• OPEN Statement

• OPEN-FOR Statement

• Closing a Cursor

• Querying Data with PL/SQL