CLOSE Statement

The CLOSE statement closes a named cursor, 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.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

close_statement ::=

Description of the illustration close_statement.gif

Semantics

cursor_name

The name of an open explicit cursor.

cursor_variable_name

The name of an open cursor variable.

host_cursor_variable_name

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 host_cursor_variable_name.

The data type of a host cursor variable is compatible with the return type of any PL/SQL cursor variable.

Examples

• Example 4-26, "EXIT in FOR LOOP"

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

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

Related Topics

In this chapter:

• "FETCH Statement"

• "OPEN Statement"

• "OPEN FOR Statement"

In other chapters:

• "Closing Explicit Cursors"