Help: sending email in pl/sql

From: Ky <keys_at_hongkong.com>
Date: Thu, 23 May 2002 17:52:03 +0800
Message-ID: <acie39$qdk$1@du05.ouhk.edu.hk>

We are using 8.1.7 with Jserver options, after I have created the necessary packages
using the sample scripts from oracle otn, I try to send a email from within pl/sql block
and obtain the following error:

Begin
*
ERROR at line 1:

ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 537
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 "ONRPROD.DEMO_MAIL", line 222
ORA-06512: at "ONRPROD.DEMO_MAIL", line 99
ORA-06512: at "ONRPROD.DEMO_MAIL", line 86
ORA-06512: at line 2

could someone pls advise what could possibly go wrong, is there any setting or step I have missed ??

thx for the help Received on Thu May 23 2002 - 04:52:03 CDT