Mutating Tables Ans Triggers

[Quoted]     We Arrived To a Very Bad Situation.

[Quoted]     We Hava Mutating Tables when we have Triggers that must update them, The [Quoted] creation of the Triggers are well done however when we try to update that tables we btain the dollowing error:

[Quoted] [Quoted]     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 [Quoted] the update using not one trigger but three triggers using PACKAGES, but for [Quoted] a newbie that is a little bit complicated .

    IS There any solution more simple ???

 Can You Answer me please ???

xmina_leiria_at_clix.pt Received on Sat Jul 21 2001 - 23:52:30 CEST