---

CLOSE Statement

The CLOSE statement closes a named cursor, thereby allowing its resources to be reused.

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 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 6-6, "FETCH Statements Inside LOOP Statements"

Related Topics

In this chapter:

• "FETCH Statement"

• "OPEN Statement"

• "OPEN FOR Statement"

In other chapters:

• "Opening and Closing Explicit Cursors"