GeekInterview.com
Series: Subject:
Question: 196 of 196

What are the characteristics of autonomous transactions?

Asked by: Interview Candidate | Asked on: Oct 2nd, 2004
Showing Answers 1 - 2 of 2 Answers
uday

Answered On : Jun 29th, 2007

Autonomous transaction defined and executedindependent of calling program.
u need to define PRAGMA AUTONOMOUS_TRANSACTION at declare section. stored procedure, function can be defined as autonomous transaction.

  
Login to rate this answer.
ajeeteng

Answered On : May 5th, 2010

View all answers by ajeeteng

Autonomous transactions refer to the ability of PL/SQL temporarily suspend the current transaction and begin another transaction.  The second transaction is known as an autonomous transaction, and functions independently from the parent code.  This is especially important for PL/SQL exception handling, as we will see in a minute.

A PL/SQL autonomous transaction has the following characteristics:

The child code runs independently of its parent.
The child code can commit or rollback & parent resumes.
The parent code can continue without affecting child work

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.