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:19:44 -0800
Message-ID: <1169619584.102630.144940@d71g2000cwa.googlegroups.com>


On 24 jan, 07:09, hasta..._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 themutatingtablewarning...
>
> > > 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 tourmutatingtable
> example ? Is t2 supposed to record the history of the number of rows
> of t2 ?

Erratum : Is t2 supposed to record the history of the number of rows of t1 ? Received on Wed Jan 24 2007 - 00:19:44 CST

Original text of this message

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