Re: Mutating Tables Ans Triggers

"Xmina" <xmina_leiria_at_clix.pt> wrote in message news:lV7W6.6152$Aw6.21577869_at_newsserver.ip.pt...
>
> We Arrived To a Very Bad Situation.
>
> We Hava 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 ???
>
> xmina_leiria_at_clix.pt
>
>
>
>

There isn't.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Jul 21 2001 - 23:52:32 CEST