Showing posts with label Autonomous Transaction. Show all posts
Showing posts with label Autonomous Transaction. Show all posts

Autonomous Transaction in oracle


Autonomous Transaction
Autonomous transactions refer to the ability of PL/SQL temporarily suspend the current transaction and begin another transaction.  The second transaction is known as an autonomous transaction. The autonomous transaction functions independently from the parent code.
An autonomous transaction has the following characteristics: