What is Autonomous transaction?

Oracle Apps Interview Questions › Category: AOL-SysAdmin › What is Autonomous transaction?
0 Vote Up Vote Down
Questions Master asked 10 years ago

and where do we use Autonomous transaction?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

Autonomous Transaction is a kind of transaction that is independent of another transaction. This kind of transaction allows you in suspending the main transaction and helps in performing SQL operations, rolling back of operations and also committing them. The autonomous transactions do not support resources, locks or any kind of commit dependencies that are part of main transaction.