Am seeing the following error in the DB alert log when the event fires.
-4091: ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see it
ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see it
I have seen people getting around this with an autonomous pragma - but cant insert as am not executing an SQL block but sending an email.
Any ideas?