Skip Headers
Oracle® Database PL/SQL Language Reference
11g Release 1 (11.1)

B28370-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 ::=

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

Related Topics