Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need workaround for Oracle Mutating table

Re: Need workaround for Oracle Mutating table

From: <hasta_l3_at_hotmail.com>
Date: 23 Jan 2007 22:09:50 -0800
Message-ID: <1169618989.987348.206410@v45g2000cwv.googlegroups.com>


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 ?

Received on Wed Jan 24 2007 - 00:09:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US