Re: Mutating Tables And Triggers

Hi,

You can not update/insert/delete a record from the table on which you have defined the Trigger.

Example. If you have written a trigger On update then in this trigger you can do the processing or update some other table and so on... but once you try to updater the same table through this trigger then MUTUTAING TABLE error occur.

Regards
Satya

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9gg73a01bip_at_drn.newsguy.com>...
> In article <S%KW6.6342$sV4.21922914_at_newsserver.ip.pt>, "Xmina" says...
> >
> >
> > We Arrived To a Very Bad Situation.
> >
> > We Have Mutating Tables when we have Triggers that must update them, The
> >creation of the Triggers are well done however when we try to update that
> >tables we btain the dollowing error:
> >
> > ORA-04091: tabela SCOTT.HORA_EXTRA está em mutação, trigger não a pode
> >ler ou modificar
> >ORA-06512: na "SCOTT.F_HORA_EXTRA", linha 6
> >ORA-06512: na linha 1
> >ORA-06512: na "SCOTT.T_HORA_EXTRA_0", linha 8
> >ORA-04088: erro durante a execução do trigger 'SCOTT.T_HORA_EXTRA_0'
> >
> > We obtain the Famous Error ORA-04091. For What we investigated we can do
> >the update using not one trigger but three triggers using PACKAGES, but for
> >a newbie that is a little bit complicated .
> >
> > IS There any solution more simple ???
> >
> > Can You Answer me please ???
> >
>
> post the trigger and we'll see if there is.
>
>
> >
Received on Sat Jul 21 2001 - 23:54:14 CEST