5. Working with Embedded SQL : Data Manipulation with Cursors : Open Cursors and Transaction Processing
 
Share this page                  
Open Cursors and Transaction Processing
Cursors affect transaction processing as follows:
Cursors cannot remain open across transactions. The COMMIT statement closes all open cursors, even if a CLOSE CURSOR statement was not issued.
A savepoint cannot be declared when a cursor is open.
If an error occurs while a cursor is open, the DBMS Server can roll back the entire transaction and close the cursor.