Oracle autonomous transaction
An autonomous transaction is an independent transaction that is
initiated by another transaction (the parent transaction).
An autonomous transaction can modify data and commit or rollback
independent of the state of the parent transaction.
The autonomous transaction must commit or roll back before the
autonomous transaction is ended and the parent transaction continues.
An autonomous transactions is available from Oracle 8i.
An autonomous transaction is defined in the declaration of a pl/sql
block. This can be an anonymous block, function, procedure, object method or
This is done by adding the statement 'PRAGMA AUTONOMOUS_TRANSACTION;'
anywhere in the declaration block.
There isn't much involved in defining a PL/SQL block as an autonomous
You simply include the following statement in your declaration section:
Autonomous transactions can be used for logging in the database
independent of the rollback/commit of the parent transaction.