Thursday, April 30, 2009

Autonomous transaction

It is an independent transaction started by the another transaction the main or parent transaction, do SQL operations, commit or rollback operations the resume back to the main transaction.

Once started an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction. 

More important autonomous transaction help you build modular reusable software components.You can use autonomous transaction in your report for writing error message in your database tables.

No comments: