Skip Headers
Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)

Part Number E10472-02
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
View PDF

OPEN FOR Statement

The OPEN FOR statement associates a cursor variable with a multiple-row query, allocates database resources to process the query, identifies the result set, and positions the cursor before the first row of the result set. (If the query has a FOR UPDATE clause, processing the query includes locking the rows of the result set—see "SELECT FOR UPDATE and FOR UPDATE Cursors".)

Topics:

Syntax

open_for_statement ::=

open_for_statement
Description of the illustration open_for_statement.gif

using_clause ::=

using_clause
Description of the illustration using_clause.gif

Semantics

bind_argument

An expression whose value replaces its corresponding placeholder in select_statement or dynamic_string at run time. You must specify a bind_argument for every placeholder.

cursor_variable_name

The name of a cursor variable. If the cursor variable is the formal parameter of a subprogram, it must not have a return type. For information about cursor variables as subprogram parameters, see "Cursor Variables as Subprogram Parameters".

dynamic_string

A string literal, string variable, or string expression; of type CHAR, VARCHAR2, or CLOB; that represents a multiple-row SQL SELECT statement (not a PL/SQL SELECT INTO statement).

See:

Oracle Database SQL Language Reference for SELECT statement syntax

host_cursor_variable_name

The name of a cursor variable that was declared in a PL/SQL host environment and passed to PL/SQL as a bind argument. The data type of the cursor variable is compatible with the return type of any PL/SQL cursor variable. Do not put space between the colon (:) and host_cursor_variable_name.

IN, OUT, IN OUT

Parameter modes of bind arguments. An IN bind argument passes its value to the select_statement or dynamic_string. An OUT bind argument stores a value that dynamic_string returns. An IN OUT bind argument passes its initial value to dynamic_string and stores a value that dynamic_string returns. The default parameter mode for bind_argument is IN.

select_statement

A string literal, string variable, or string expression; of type CHAR, VARCHAR2, or CLOB; that represents a multiple-row SQL SELECT statement (not a PL/SQL SELECT INTO statement).

See:

Oracle Database SQL Language Reference for SELECT statement syntax

using_clause

Specifies bind arguments.

Restrictions on using_clause 

Examples

Related Topics

In this chapter:

In other chapters: