Rollback returns both the main and temporary stores to their former state. It also releases locks:
Transaction rollback releases all locks held by the transaction.
Rollback to a savepoint releases all locks acquired after that savepoint.
Rollback of open cursors deletes all cursor information and closes both hold and non-hold cursors:
Transaction rollback closes all cursors. It does not matter whether the cursor was opened in the transaction being rolled back, or in an earlier transaction.
Rollback to a savepoint closes all cursors opened after that savepoint.
For more information on cursors, see “Cursors in transactions.” For more information on rollback to a savepoint, see “Rolling back to a savepoint.”
