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
- Follow-Ups:
- RE: uses of autonomous transactions
- From: Ken Naim
- References:
- uses of autonomous transactions
- From: Rick Ricky
- RE: uses of autonomous transactions
- From: Ken Naim
- Re: uses of autonomous transactions
- From: Jonathan Lewis
Other related posts:
- » uses of autonomous transactions
- » Re: uses of autonomous transactions
- » Re: uses of autonomous transactions
- » RE: uses of autonomous transactions
- » RE: uses of autonomous transactions
- » RE: uses of autonomous transactions
- » Re: uses of autonomous transactions
- » Re: uses of autonomous transactions
- » RE: uses of autonomous transactions
- RE: uses of autonomous transactions
- From: Ken Naim
- uses of autonomous transactions
- From: Rick Ricky
- RE: uses of autonomous transactions
- From: Ken Naim
- Re: uses of autonomous transactions
- From: Jonathan Lewis