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

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.

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0304231141.7e37f0f1_at_posting.google.com>...
> schumacherfan2003_at_yahoo.com (leo) wrote in message news:<79d24144.0304230037.621ddabf_at_posting.google.com>...
> > Hello,
> >
> > I am trying to use java mailing API's to send mails from Oracle
> > database. I am able to import my java classes successfully, but when i
> > resolve these using the -resolve option when using loadjava, i get
> > ORA-29534.
> >
> > Now i know that this problem occurs because the classes refrenced in
> > my java class do not exist in the db. My class uses 6 classes from the
> > javax.mail package. If i import these too using loadjava, the problem
> > resurfaces as these 6 classes use many many other classes from
> > numerous java API packages and so on and on......
> >
> > What is the solution to this? Do i have to load in the very big jar
> > file which contains ALL java API classes? I use weblogic server, and
> > this would imply loading weblogic.jar into oracle which sounds absurd
> > to me.
> >
> > Please revert back with suggestions.
> >
> > Regards,
> > Leo.
>
>
> If it is simple mail then you can use UTL_SMTP package or is that not an option?
>
> Regards
> /Rauf Sarwar
Received on Wed Apr 23 2003 - 23:47:44 CDT