thx for all yr help, it seems I haven't run some of the setup scripts just
as said.
"Ky" <keys_at_hongkong.com> ¼¶¼g©ó¶l¥ó news:acie39$qdk$1_at_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 Fri May 24 2002 - 01:43:52 CDT
