-- TABLE is mutating -- AAAGHHHHHHHHH!

Hello all,

I have a triggers which is executed on an update of tabel A. In the trigger I update TableB. The update trigger AGAIN updates table A.

Well, As Expected the "ORA-04091: table A is mutating, trigger/function may not see it"-error occurs. No problem.

But, I want to include some code in triggerB that sais: "If tableA is mutating then do nothing"

Is this possible??

Thanks,
Andre van Rossem Received on Tue Jun 17 2003 - 13:15:23 CEST