RE: Class does not exist error
This is supposed to be BUG# 1260358 and fixed in 8.1.6.1, but I can't find any info on that BUG... You may want to try to execute the $ORACLE_HOME/rdbms/admin/iniplsj.sql script as user SYS. This is normally called as part of initjvm.sql, but some releases skipped it. If I remember correctly, I had to run that manually, too, a few weeks ago when I tried the e-mail thing. Of course, DO THIS ON A TEST DATABASE FIRST and don't blame me if it don't work. Good luck! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 29, 2002 8:00 AM To: Multiple recipients of list ORACLE-L Hi, Rick I'm not 100% sure, but it I think, the problem is Server/JServer version. The script will be OK on 8.1.7. 8.1.7 JVM is very different from 8.1.6 HTH Vadim -Original Message- Sent: Tuesday, January 29, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error "class oracle/plsql/net/TCPConnection does not exist" Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Class does not exist error
Hi, Rick I'm not 100% sure, but it I think, the problem is Server/JServer version. The script will be OK on 8.1.7. 8.1.7 JVM is very different from 8.1.6 HTH Vadim -Original Message- Sent: Tuesday, January 29, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error "class oracle/plsql/net/TCPConnection does not exist" Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Class does not exist error
[EMAIL PROTECTED] wrote: >[EMAIL PROTECTED] wrote: > >>Hi DBAs, >> >>Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client >> >>A list member sent me a pl/sql script for sending mail. It compiles ok when >>I run it I get the following error >> >>"class oracle/plsql/net/TCPConnection does not exist" >> >>Any ideas on how to correct this? I do not know if I have to do something >>on client side or server side >> >>Thanks >>Rick >> > >Where do you think the stored procedure is executed? Your runtime >message comes from a dynamically loaded routine. If you find >TCPConnection.class it may be CLASSPATH or similar which is improperly >set on your server. > or it could not be installed on the database JVM. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A list is only as strong as its weakest link. - Don Knuth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Class does not exist error
Rick, Run the initplsj.sql file found under the oracle_home/rdbms/admin directory via the SYS account. It will load the classes you are missing. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 29, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error "class oracle/plsql/net/TCPConnection does not exist" Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Class does not exist error
[EMAIL PROTECTED] wrote: > > Hi DBAs, > > Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client > > A list member sent me a pl/sql script for sending mail. It compiles ok when > I run it I get the following error > > "class oracle/plsql/net/TCPConnection does not exist" > > Any ideas on how to correct this? I do not know if I have to do something > on client side or server side > > Thanks > Rick > Where do you think the stored procedure is executed? Your runtime message comes from a dynamically loaded routine. If you find TCPConnection.class it may be CLASSPATH or similar which is improperly set on your server. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Class does not exist error
Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error "class oracle/plsql/net/TCPConnection does not exist" Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).