What is autonomous transaction?Autonomous transactions have the ability to leave the context of calling transaction, then perform an independent transaction, and again return to the calling transaction without affecting its state. It has no link to the calling transaction, thus allowing only committed data to be shared between the 2 transactions.
Following types can be defined as autonomous transactions:
- Stored procedures
- Local procedures and functions defined within a PL/SQL block
- Packaged Procedures and functions
- Type methods
- Top level anonymous blocks