Re: uses of autonomous transactions

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx
  • Date: Thu, 29 May 2008 12:50:02 -0700

n Sat, May 24, 2008 at 2:26 AM, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
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

Other related posts: