Closing a Cursor

CLOSE statement

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.

SQL CLOSE cursor-name

COMMIT and ROLLBACK statements

A COMMIT or ROLLBACK statement closes all cursors and cancels all cursor declarations.