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