Effect of Rollback

Rollback returns both the main and temporary stores to their former state.

It also releases locks:
Rollback of open cursors deletes all cursor information and closes both hold and non-hold cursors:
Related concepts
Cursors in Transactions
Rollbacks to Savepoints
Cursors and Versioning