Launch procedure from within a trigger
We have a trigger and a procedure. The procecure is launched in from within the trigger. The procedure launched from within trigger is supposed to send an email. When the trigger is executed we are not seeing the procedure to be launched. The procedure can be launched standalone and it runs fine.
Both the trigger and the procedure are both owned by the same Oracle account/user. Is there some specificial setup/privilege that needs to be setup such that the noted trigger can launch the procedure?
Below is extract of portion of trigger where the procedure is launched. Specifically bellow it's the "if(v_agency='R') then..." portion with the Advance.ucd_wc_dohandle_authcode_upd(v_awc_trans_id, v_authcode); being the procedure that is trying to be launched from within the procedure.