hi guys!
is it possible to disable a trigger while during he`s operetion? the problem is that i want that a trigger reacts on updates of a table and then when a condition is activeted the trigger makes him self a update on the table he sits on, so i supose that he reactivete him selfs again and that cause the error i get: ORA-04091: table INVEST.D_NEWS is mutating, trigger/function may not see it
please help me to solve this, thank you
kemo
is it possible to disable a trigger while during he`s operetion? the problem is that i want that a trigger reacts on updates of a table and then when a condition is activeted the trigger makes him self a update on the table he sits on, so i supose that he reactivete him selfs again and that cause the error i get: ORA-04091: table INVEST.D_NEWS is mutating, trigger/function may not see it
please help me to solve this, thank you
kemo