Re: ORA-29534: referenced object could not be resolved

Hi Rauf,

I looked through the RFC. BUt wat is baffling to me is that why is UTL_SMTP not able to send the mail while java is able to. I loaded java into Oracle database and it sends mail successfully, to same recipient from the same sender via same smtp server, as i am trying from oracle.

Warm regards,
Leo.

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0304241348.16407405_at_posting.google.com>...
> 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 - 22:26:08 CDT