Re: uses of autonomous transactions
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 22 May 2008 11:10:56 -0500 (CDT)
Message-ID: <57287.12.17.117.251.1211472656.squirrel@12.17.117.251>
Date: Thu, 22 May 2008 11:10:56 -0500 (CDT)
Message-ID: <57287.12.17.117.251.1211472656.squirrel@12.17.117.251>
Procedures called from logon and startup database triggers come to mind.
I've coded a "10046" set of procedures that uses it to isolate it from the
current transaction (obviously). I've also used it to do ancillary
application tasks like maintaining user preferences.
My $.02,
Rich
> has anyone found a use for this other than for logging?
> 1. doing stuff
> 2. log what i am doing. commit it and don't want to commit do stuff
> 3. continue doing stuff
>
> anyone use it for anything else?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 22 2008 - 11:10:56 CDT