Re: Send mail from 8i SMTP package

Hi!
Still problem. The JVM was not installed correctly and I'm now trying to install it manually. But running initjvm.sql fails with: ORA-04021: timeout occurred while waiting to lock object SYS.INITJVMAUX At Metalink I've found Note:115347.1 which explains a similar problem in VMS (?). If this is the path to follow, how can I include Java Aurora external option without reinstall the whole Oracle 8.1.6 database?

TimKArnold skrev i meldingen
<20000827171500.11419.00000631_at_ng-fn1.aol.com>...
>If you can go to Metalink, do a search on
>utl_smtp. You need to install a few things. -
>there are 2 scripts and a jar.
>Actually -
>'class oracle/plsql/net/TCPConnection does not exist'
>indicates that the jar was NOT installed.
>I believe it is in the plsql directory.
>
>email for more details if you cannot find it.
>
>>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 Thu Aug 31 2000 - 07:32:47 CDT