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
mailcon := utl_smtp.open_connection('localhost');
'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('email@example.com','firstname.lastname@example.org','testsms')
BEGIN send_sms('email@example.com','firstname.lastname@example.org','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.
This is more of a PL/SQL question - this is the Oracle Designer Forum. Try asking in the SQL and PL/SQL Forum - SQL and 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.