AW: What do you use autonomous transactions for?

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

That's a good idea. I think the only drawback here is: What if part of your work done within the trigger is=20 ok, before you encounter a problem. You can't rollback=20 what you've done in your AT then. You would have to do=20 a "roll-your-own"-rollback by keeping track of what you=20 changed and issuing a second AT to undo your work. That might be a real performance problem, depending of=20 how often your triggers are executed and what kind of=20 work they're supposed to do.

Stefan

-----Urspr=FCngliche Nachricht-----
Von: David.Schmoldt_at_gazettecommunications.com [mailto:David.Schmoldt_at_gazettecommunications.com] Gesendet: Dienstag, 17. Februar 2004 00:29 An: oracle-l_at_freelists.org
Betreff: RE: What do you use autonomous transactions for?=20

I *think* I read you can use autonomous transactions in table triggers = to
avoid some mutating table situations. Haven't tried it myself.

I do use them a lot in logging the progress of long-running jobs, = logging
errors before rollback, etc.

Dave

> -----Original Message-----
> From: Powell, Mark D [mailto:mark.powell_at_eds.com]
> Sent: Monday, February 16, 2004 1:29 PM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: What do you use autonomous transactions for?=20

>=20
>=20

> I would think that error message logging, debugging, and=20
> auditing are the
> primary uses of user created anonymous transactions.

>=20
>=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ryan
> Sent: Monday, February 16, 2004 2:21 PM
> To: oracle-l_at_freelists.org
> Subject: What do you use autonomous transactions for?=20

>=20
>=20

> The only thing I have used them for is logging dbms_jobs to=20
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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

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
----------------------------------------------------------------
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
-----------------------------------------------------------------

Received on Tue Feb 17 2004 - 03:20:48 CST