• Cursors cannot remain open across transactions. The COMMIT statement closes all open cursors, even if a CLOSE cursor statement was not issued.

• If an error occurs while a cursor is open, the DBMS Server can roll back the entire transaction and close the cursor.