Autonomous Transcation

What are advantages of Autonomous Transcation?

ramesh.akula9
Profile Answers by ramesh.akula9 Questions by ramesh.akula9
Sep 5th, 2008
2
2124

Showing Answers 1 - 2 of 2 Answers

namita04
Profile Answers by namita04

Dec 23rd, 2009

A autonomous transaction starts with the first SQL statement of the PL/SQL block and ends with a commit.

raghunadhn
Profile Answers by raghunadhn

Mar 3rd, 2010

Autonomous transactions are independent of the main transactions.

You can commit the changes in the other tables using these transactions, even though the main transaction is not a success. Depending on one transaction, you can commit/rollback the other transactions.