|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Using Embedded SQL, 10 of 15
After you have used a cursor to retrieve all the data in its active set, you should close the cursor. If you want to use the cursor again to retrieve data starting from the first row of its active set, then you can use the OPEN statement without having to declare the cursor again. The CLOSE statement does not cancel a cursor's declaration; it only renders the active set undefined.
The following is the syntax of the CLOSE statement.
A COMMIT or ROLLBACK statement closes all cursors and cancels all cursor declarations.