Cursor management

Managing a cursor is similar to managing a file in a programming language. The following steps manage cursors:

Declare a cursor for a particular SELECT statement or procedure using the DECLARE statement.
Open the cursor using the OPEN statement.
Use the FETCH statement to retrieve results one row at a time from the cursor.
A row not found warning signals the end of the result set.
Close the cursor using the CLOSE statement.

By default, cursors are automatically closed at the end of a transaction (on COMMIT or ROLLBACK statements). Cursors opened using the WITH HOLD clause will stay open for subsequent transactions until explicitly closed.

Cursor management

See also