Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-29534: referenced object could not be resolved
schumacherfan2003_at_yahoo.com (leo) wrote in message news:<79d24144.0304232047.2519a0c6_at_posting.google.com>...
> hi Rauf,
>
> Myself being a java guy, i didnt know abt the utl_smtp package. I
> intend to send a simple smtp mail and its appropriate that i use this
> builtin API.
>
> 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.
>
Leo,
501 return code is sent back by your mail server. Please refer to SMTP
protocol defined in RFC 821 for specific return codes. Here is an old
but good document,
http://www.freesoft.org/CIE/RFC/821/
Regards
/Rauf Sarwar
Received on Thu Apr 24 2003 - 16:48:12 CDT