2 Replies Latest reply: May 4, 2013 12:23 AM by damorgan RSS

    send mail procedure is giving me the error

    935684
      Hi all,

      I have created ACL and given connect and resolve privileges and assign mail host.
      After that I am running the procedure which is using to send a mail which is using UTL_SMTP package. While running I am getting the following error


      Procedure Name:SENDMAIL


      ERROR at line 1:
      ORA-24247: network access denied by access control list (ACL)
      ORA-06512: at "SYS.UTL_TCP", line 17
      ORA-06512: at "SYS.UTL_TCP", line 267
      ORA-06512: at "SYS.UTL_SMTP", line 161
      ORA-06512: at "SYS.UTL_SMTP", line 192
      ORA-06512: at "SENDMAIL", line 12
      ORA-06512: at line 16


      Please help me out this.