ORA-20002: 501 Bad address syntax
Date: 23 Apr 2003 21:51:04 -0700
Message-ID: <79d24144.0304232051.524481b_at_posting.google.com>
Hi,
[Quoted] [Quoted] I intend to send a simple smtp mail using the builtin UTL_SMTP package.
But i get the following error:-
ORA-20002: 501 Bad syntax error
Here is my code:-
CREATE OR REPLACE PROCEDURE mail
IS
BEGIN
DECLARE
v_connection UTL_SMTP.CONNECTION;
BEGIN v_connection := UTL_SMTP.OPEN_CONNECTION(<my host here>,25); dbms_output.put_line('Connection Opened');
UTL_SMTP.HELO(v_connection,<my host here>); dbms_output.put_line('After calling helo');
UTL_SMTP.MAIL(v_connection,'test_at_myhost.com'); dbms_output.put_line('Sender set');
UTL_SMTP.RCPT(v_connection,'test1_at_myhost.com'); dbms_output.put_line('Recipient Set');
UTL_SMTP.DATA(v_connection,'Sent From PL/SQL'); dbms_output.put_line('Message body set');
UTL_SMTP.QUIT(v_connection);
dbms_output.put_line('Connection Closed');
end;
END;
/
Here is the output:-
SQL> exec mail
Connection Opened
After calling helo
BEGIN mail; END;
*
ERROR at line 1:
ORA-20002: 501 Bad address syntax ORA-06512: at "SYS.UTL_SMTP", line 86 ORA-06512: at "SYS.UTL_SMTP", line 204 ORA-06512: at "ADMIN.MAIL", line 13 ORA-06512: at line 1
I tried sending mails to my smtp server via java mailing API and i am successful. So i am wondering wat i am doing wrong up there in Oracle. I have JServer enabled, i also ran the initplsj.sql successfully.
Please help.
Regards,
Leo.
Received on Thu Apr 24 2003 - 06:51:04 CEST