AW: What do you use autonomous transactions for?

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Tue, 17 Feb 2004 10:11:33 +0100
Message-ID: <87F172BCF111D0489340AB3CB16A011E0DD1C1@EBMS20.bov.int>

We use ATs for pretty much all the Error/Warning/Info/Debug stuff. = Since you
don't want to interfere with the calling transaction and leave = potential
commits/rollbacks to the calling context, we use ATs for that. It also gives you a good seperation between different developer's = concerns:
They can both work on their thing without=20 having to care too much about corrupting their peer's transactions.

Stefan

-----Urspr=FCngliche Nachricht-----

Von: Ryan [mailto:ryan.gaffuri_at_cox.net]
Gesendet: Montag, 16. Februar 2004 20:21 An: oracle-l_at_freelists.org
Betreff: What do you use autonomous transactions for?=20

The only thing I have used them for is logging dbms_jobs to tables. I = do not
want the transaction to commit, but I want to track my progress.=20 What have you used them for? Anything interesting?=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Feb 17 2004 - 03:11:33 CST