Re: uses of autonomous transactions

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