SQL Language Guide > Embedded SQL > Data Manipulation with Cursors > Open Cursors and Transaction Processing
Was this helpful?
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.
If an error occurs while a cursor is open, the Actian Data Platform can roll back the entire transaction and close the cursor.
Last modified date: 12/12/2024