|Oracle® Database PL/SQL Language Reference
12c Release 1 (12.1)
|PDF · Mobi · ePub|
FOR statement associates a cursor variable with a 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
UPDATE clause, then the
FOR statement locks the rows of the result set.
Name of a cursor variable. If
cursor_variable is the formal parameter of a subprogram, then it must not have a return type. For information about cursor variables as subprogram parameters, see "Cursor Variables as Subprogram Parameters".
Name of a cursor variable that was declared in a PL/SQL host environment and passed to PL/SQL as a bind variable. Do not put space between the colon (:) and
The data type of a host cursor variable is compatible with the return type of any PL/SQL cursor variable.
SELECT statement (not a PL/SQL
INTO statement). Typically,
select_statement returns multiple rows.
See:Oracle Database SQL Language Reference for
String literal, string variable, or string expression of the data type
CLOB, which represents a SQL
SELECT statement. Typically,
dynamic_statement represents a SQL
SELECT statement that returns multiple rows.
Specifies bind variables.
Parameter modes of bind variables. An
IN bind variable passes its value to the
OUT bind variable stores a value that
dynamic_string returns. An
OUT bind variable passes its initial value to
dynamic_string and stores a value that
dynamic_string returns. Default:
Expression whose value replaces its corresponding placeholder in
dynamic_string at run time. You must specify a
bind_argument for every placeholder.
Note:Bind variables can be evaluated in any order. If a program determines order of evaluation, then at the point where the program does so, its behavior is undefined.
bind_argument cannot be an associative array indexed by string.
bind_argument cannot be the reserved word
To pass the value
NULL to the dynamic SQL statement, use an uninitialized variable where you want to use
NULL, as in Example 7-7.