Re: Mutating Tables And Triggers

[Quoted] 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.

>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp