Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06576/29540
laly wrote:
>
> Hi everybody,
>
> I have an error under Oracle while trying to execute a script
> admin/rdbms/initplsj.sql.
>
> I want to send email from Oracle. I tried to use the UTL_SMTP package
> which is installed on my server (Oracle 8i 8.1.6.2 with JServer).
> I got this error :
> 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 "PPWEB.SEND_MAIL", line 9
> ORA-06512: at line 2.
>
> I was told that maybe executing initplsj.sql could solve my problem
> but it's not the case.
>
> Thanks to anybody for any clue.
>
> Laly.
Is your CLASSPATH variable set? Does the file exist (line 1 of the
error stack? And, are the permissions correct? Does the user have
EXECUTE on the package?
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Tue Nov 13 2001 - 10:51:49 CST