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]