Was this helpful?
Effects of Aborting Transactions
When a statement or transaction is aborted:
Rolling back a single statement does not cause the DBMS to release any locks held by the transaction. Locks are released when the transaction ends.
If cursors are open, the entire transaction is always aborted.
When an entire transaction is aborted, all open cursors are closed, and all prepared statements are invalidated.
Last modified date: 01/30/2023