Re: Java Server eXecution environment setup for Oracle RDBMS server 8.1.7.4

bgilon_at_free.fr (Benoit Gilon) wrote in message news:<db83fc55.0310070136.7a298ba_at_posting.google.com>...
> Hello,
>
> 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
Hello,

OK, I have checked and the Java software must be installed on the database in order for the UTL_TCP and UTL_SMTP packages to work...

Benoît Received on Tue Oct 07 2003 - 19:45:07 CEST