Trigger on A table causes reconcile to fail

708
1
07-30-2010 01:14 PM
AnastasiaAourik
New Contributor II
Have a trigger on an A table that updates a MODDATE attribute field with sysdate - it updates fine in the A table but when I do a reconcile I get error:

The version could not be reconciled.
Underlying DBMS error[ORA-04091:table HOUSTON.A189 is mutating, trigger/function may not see it
ORA-06512: at HOUSTON.CONTR_TRG, line 9
ORA04088:error during execution of trigger "HOUSTON.CONTR_TRG][HOUSTON.CONTR_OVL]
0 Kudos
1 Reply
TomBrown
New Contributor
You'll have to modify your trigger, its mutating. See Oracle's documentation.

Good luck.
0 Kudos