Email procedure error--TCPConnection 1

[stilllwaiting]

I've been trying to build a simple Email procedure in Oracle 8.1.6


I've installed the utl_smtp and related packages, and built
the procedure via the instructions in the utlsmtp.sql file
and advice given in a different thread. However, when i try
to run it I get this error.


ORA-29540: class oracle/plsql/net/TCPConnection does not exist


A man had a different problem in a separate thread, and was told to.


>As the error message states, you do not have the
>TCPConnection class in the subdirectory where Oracle
>expects it. You need to find that class and place it
>where Oracle is looking for it.

However, I've searched my database thoroughly, and can not
find any reference to TCPConnection anywhere. Which is okay, because I wouldn't know how to install it anyway

Would anyone know where I could locate this class,
and give some brief instruction on how to load/install it?

thank you,

Joe Winskye

joe@onesourcedata.com

 

[MikeJones]

Did you get an error like this??

SQL> @test_mail
stat 1
error ORA-29540: class oracle/plsql/net/TCPConnection does not exist

PL/SQL procedure successfully completed.

SQL> !oerr ora 29540
29540, 00000, "class %s does not exist"
// *Cause: Java method execution failed to find a class with the indicated name.

// *Action: Correct the name or add the missing Java class.


The Oracle documentation says that the following Java classes need to be installed for it to run. I installed them and it worked fine!!

%ORACLE_HOME/javavm/plsql/jlib/initjvm.sql
%ORACLE_HOME/rdbms/java/install/initplsj.sql

 

[RandyD]

If you give up, try the utility EZDBMail...

http://www.ezdbmail.com

it works well.

Randy

 

[stilllwaiting]

I get the first error

>SQL> @test_mail
>stat 1
>error ORA-29540: class oracle/plsql/net/TCPConnection does >not exist

I tried your suggestion, and I'm having a heck of a time installing the initjvm.sql file.

If there's any othere ideas on what else I might need, I'd appritiate it.