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