Re: Send mail from 8i SMTP package

This is just a w.a.g. but it looks like you are getting a class not found error, so I assume that utl_smtp is calling a java class and that class is not found. Maybe look at the classpath variable for the unix user that start oracle.

I will be doing the same thing myself eventually, so be sure to post the solution when you find it!
mike

Per Sverre Stiansen <per.sverre.stiansen_at_caa.no> wrote in message news:6WLp5.3036$A_.62063_at_news1.online.no...
> Hi all!
> I'm trying to use the SMTP package to send email but have some problems.
 It
> is probably due to some bad environment variables or missing installed
> components. Running Oracle 8.1.6 on Solaris 2.6. The send_mail procedure
 is
> like (based on the example from Oracle documentation):
>
> PROCEDURE send_mail (sender IN VARCHAR2,
> recipient IN VARCHAR2,
> message IN VARCHAR2)
> IS
> mailhost VARCHAR2(30) := '<mailhost.mydomain.com>';
> mail_conn utl_smtp.connection;
> BEGIN
> mail_conn := utl_smtp.open_connection(mailhost, 25);
> utl_smtp.helo(mail_conn, mailhost);
> utl_smtp.mail(mail_conn, sender);
> utl_smtp.rcpt(mail_conn, recipient);
> utl_smtp.data(mail_conn, message);
> utl_smtp.quit(mail_conn);
> EXCEPTION
> WHEN OTHERS THEN
> -- Handle the error
> END;
>
> After calling this procedyre I'm receiving the following error:
>
> SQL> exec send_mail('test','test','Test')
> BEGIN send_mail('test','test','Test'); END;
>
> *
> ERROR at line 1:
> ORA-29540: class oracle/plsql/net/TCPConnection does not exist
> ORA-06512: at "SYS.UTL_TCP", line 533
> ORA-06512: at "SYS.UTL_TCP", line 199
> ORA-06512: at "SYS.UTL_SMTP", line 99
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "OSNASS.SEND_MAIL", line 8
> ORA-06512: at line 1
>
>
> SQL>
>
> Can anyone point me in the right direction to solve this problem?
>
> --Peres--
>
>
>
Received on Sun Aug 27 2000 - 06:07:30 CEST