Java Server eXecution environment setup for Oracle RDBMS server 8.1.7.4

[Quoted] I would like to use the UTL_SMTP package from one client application. However, whenever I tried to execute a function part of this package I get the following message from the server:
"

SQL> set serveroutput on

Failed to send email due to the following error: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

PL/SQL procedure successfully completed. SQL> exit
$ 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.
"

As this is a standard Oracle package, I think that the Java is already loaded in the database and there is no need to run the loadjava utility.

Do you have an idea about what to do to solve this issue?

Thank you for reading and for any help on this.

Regards,
Benoît Gilon Received on Tue Oct 07 2003 - 11:36:11 CEST