Parameters—Open Statement
This statement has the following parameters:
cursor_variable
Specifies the name of a local or global reference variable that points to an object of type CursorObject. This variable cannot have a null value.
select_statement
Specifies any legal select statement. If you open the cursor for update, its associated select statement can reference only one table.
update_clause
Defines the operations that you intend to perform on the rows retrieved by the select statement. This clause can have any of the following formats:
readonly [deferred | direct] update of column{, column}
column
Specifies the name of a column in the table that you intend to update. You cannot update a column that is not included in this list.