Solved

Oracle apps technical (pragma autonomous transaction)

Posted on 2013-06-26
2
650 Views
Last Modified: 2013-06-26
Can anyone post a best example for pragma aotonomous transaction in pl/sql, and a document which explains in detail about it.
0
Comment
Question by:Aparanjith
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39279737
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
 

Author Comment

by:Aparanjith
ID: 39279762
Hey thanks for the reply slightwv.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is the version of ojdbc6.jar 2 59
ORA-01008: not all variables bound. 6 57
Get the parent node - XMLTYPE 9 73
Oracle Pivot Question 8 62
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question