|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Using Embedded SQL, 8 of 15
After the SQL DECLARE CURSOR command has associated a cursor with a selection of data, you use the SQL OPEN statement to get ready to retrieve the data. These commands for a particular cursor:
The following is the syntax of the SQL command with an OPEN statement as an argument.
The SQL OPEN command:
A cursor's active set is determined when it is opened, and it is not updated later. Therefore, changing the value of an input host variable after opening its cursor does not affect the cursor's active set.