Oracle apps technical (pragma autonomous transaction)

Can anyone post a best example for pragma aotonomous transaction in pl/sql, and a document which explains in detail about it.
AparanjithAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Can't really come up with a 'best' example.

It is basically a procedure or function that acts independent of the transaction that calls it.

The doc link below has an example:

Autonomous transactions are useful for actions that must be performed independently, regardless of whether the calling transaction commits or rolls back. For example, in a stock purchase transaction, you want to commit customer data regardless of whether the overall stock purchase goes through. Additionally, you want to log error messages to a debug table even if the overall transaction rolls back.


The docs have what you need:
http://docs.oracle.com/cd/E11882_01/server.112/e25789/transact.htm#CNCPT417
0
 
AparanjithAuthor Commented:
Hey thanks for the reply slightwv.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.