Re: uses of autonomous transactions
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 29 May 2008 12:50:02 -0700
Message-ID: <bf46380805291250s138e65f3nab51ceb152ea2867@mail.gmail.com>
Date: Thu, 29 May 2008 12:50:02 -0700
Message-ID: <bf46380805291250s138e65f3nab51ceb152ea2867@mail.gmail.com>
n Sat, May 24, 2008 at 2:26 AM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
wrote:
>
> For example you can avoid mutating table
>> trigger errors with them,
>>
>
> With a high probability that most people don't realised what
> the side-effects of read-consistency are going to do, and end up with
> incorrect data.
>
>
I didn't see that one.
Use of triggers to avoid mutating tables is generally a band-aid approach to
dealing
with sub-optimal database design.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 29 2008 - 14:50:02 CDT