Re: Need workaround for Oracle Mutating table

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 24 Jan 2007 10:43:35 -0800
Message-ID: <1169664210.304810@bubbleator.drizzle.com>

hasta_l3_at_hotmail.com wrote:
> On 23 jan, 18:30, DA Morgan <damor..._at_psoug.org> wrote:

>> hasta..._at_hotmail.com wrote:
>>> swapnil.k..._at_gmail.com a écrit :
>>>> Thanks DA Morgan. It solved the problem. Thanks a lot for the help. I
>>>> referred the "Autonomous Transaction" and thats what i needed. <I'll
>>>> definately think over remodelling it.>
>>> Swapnil,  it is rare that an autonomous transaction is a
>>> solution to the mutating table warning...
>>> Could we see your solution ?
>> You can find one example at:http://www.psoug.org/reference/table_trigger.html
>> --

>
> Daniel, what is the exact specification of the code in tour mutating
> table
> example ? Is t2 supposed to record the history of the number of rows
> of t2 ?
>
> --- Raoul

In theory it should, AFTER INSERT, record the number of records it found in T1, the table on which it is located, into T2 for auditing purposes.

It is a rotten piece of code but it demonstrates the concept.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Jan 24 2007 - 12:43:35 CST