Autonomous transactions

What is an autonomous transaction?

Questions by sidd_130

Showing Answers 1 - 6 of 6 Answers

VASU

  • Oct 20th, 2012
 

BY USING AUTONOMOUS TRANSACTION
WE GET THE FOLLOWING ADVANTAGES
WE PROCEDURE HAVING TRANSACTIONS STATEMENTS WE CALL PROCEDURE AUTOMATICALLY EFFECT THE ABOVE TRANSACTIONS ALSO TO OVERCOME THAT PROBLEM WE HAVE TO USE AUTONOMOUS TRANSACTION..

  Was this answer useful?  Yes

Sonal

  • Nov 7th, 2012
 

The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction. A subprogram marked with this pragma can do SQL operations and commit or roll back those operations, without committing or rolling back the data in the main transaction.

A trigger or procedure can be marked as autonomous by declaring it as PRAGMA AUTONOMOUS_TRANSACTION;.

Keyword Pragma signifies that the statement is a pragma (compiler directive). Pragmas are processed at compile time, not at run time.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions