Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: sending email in pl/sql
Sounds like the user doesn't have access to the package...?
JP
"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 - 14:20:35 CDT