RE: Ora 29540 error

We were finally able to get this redone.

Thank you so much for your help.

Randy R. Pace
Development Team Leader

Accela, Inc.
9662 South 700 East
Sandy
UT, 84070

Tel: 801 495 9300
Fax: 801 495 9301

www.accela.com <http://www.accela.com>

-----Original Message-----
Sent: Wednesday, December 04, 2002 1:27 PM To: Multiple recipients of list ORACLE-L

Randy,

I don't think the JVM is missing.

try installing the $ORACLE_HOME/plsql/jlib/plsql.jar file using sqlloader. the class files from this file are what are missing.

hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, December 04, 2002 2:10 PM To: Multiple recipients of list ORACLE-L

Install the JVM...see MetaLink Note:156477.1

Jeff Herrick

On Wed, 4 Dec 2002, Randy Pace wrote:

>
> I get the following when trying to use the utl_tcp package on 8.1.7
> database.
>
>
> The following error has occurred:
>
> 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 102
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at "KIVA.RP_SEND_MAIL", line 51
> ORA-06512: at line 5
>
> What is missing from the database in order for that to run?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: jherrick_at_igs.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Randy Pace
  INET: rpace_at_accela.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).