Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: sending email in pl/sql
Ky,
I think that the utl_smtp package relies on Java - the CLASS keyword in the error message seems to indicate that the java oracle option is not installed.
Jack Silvey
"Ky" <keys_at_hongkong.com> wrote in message 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 Thu May 23 2002 - 12:33:44 CDT