Sending email with UTL_MAIL fails(ORA-24247) when call is made from a procedure.
Sending email with UTL_MAIL fails(ORA-24247) when call is made from a procedure. 24247. 00000 - "network access denied by access control list (ACL)" SHOW parameter smtp NAME TYPE VALUE --------------- ------ -------------------------------------------- smtp_out_server string ficticious.com sending emails with UTL_MAIL.send_attach_varchar2 is working perfectly fine, but wrapping UTL_MAIL.send_attach_varchar2 in a procedure compiles successfully but executing the procedure ends up in ORA-24247 error. Wrapper procedure for UTL_MAIL.send_attach_varchar2 create or replace procedure snd_email_atch is begin UTL_MAIL.send_attach_varchar2 ( sender => 'sendemail@ficticious.com', recipients => 'sendemail@ficticious.com', cc => 'scandata@ficticious.com', bcc => 'sendemail@ficticious.com', subjec