1 Reply Latest reply: Oct 17, 2012 10:24 PM by jflack RSS

    Network Access Denied Error

      Dear All,

      I have PL/SQL Code to send SMS, as below.

      create or replace procedure SEND_SMS
      p_sender in varchar2,
      p_recipient in varchar2,
      p_message in varchar2
      ) as
      mailcon utl_smtp.connection;
      mailcon := utl_smtp.open_connection('localhost');
      utl_smtp.mail(mailcon, p_sender);
      utl_smtp.rcpt(mailcon, p_recipient);
      'From: ' || p_sender || utl_tcp.crlf || 'To: ' || p_recipient ||
      utl_tcp.crlf || 'Subject: SMS From Database' || utl_tcp.crlf || p_message);

      on it execution, get the error message as:

      SQL> exec send_sms('kapil.relan@gmail.com','8888819237@ideacellular.net','testsms')
      BEGIN send_sms('kapil.relan@gmail.com','8888819237@ideacellular.net','testsms'); END;

      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 246
      ORA-06512: at "SYS.UTL_SMTP", line 127
      ORA-06512: at "SYS.UTL_SMTP", line 150
      ORA-06512: at "SCOTT.SEND_SMS", line 9
      ORA-06512: at line 1

      Not to able to diagnose. please help. thnx in advance.
        • 1. Re: Network Access Denied Error
          This is more of a PL/SQL question - this is the Oracle Designer Forum. Try asking in the SQL and PL/SQL Forum - PL/SQL

          But I'll give you a clue - Oracle 11g requires privileges to be granted to users of UTL_TCP to specify what servers the user may connect to. Read the 11g version of the PL/SQL Packages and Types manual.