Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need workaround for Oracle Mutating table
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
![]() |
![]() |