Mutating Tables And Triggers

    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 ??? Received on Sat Jun 16 2001 - 17:24:06 CEST