Sending email in oracle 8i strored procedures

I am trying to send email via a java stored procedure using Oracle 8i.

I have loaded the mail.jar file (uncompressed) into an Oracle 8.1.5 database, along with a class file that sends a simple email message. The code has been tested and works outside of the database.

A function was created that uses the 'email' class file created so that it could be called from a pl/sql procedure. This new function passes back a success message or the java exception message if it fails.

The error message that I am receiving is:

javax.mail.NoSuchProviderException: No provider for Address type: rfc822

From other postings that I have read it seems that the reason for this error is because files in the meta-inf directory of the mail.jar file are not being found. In searching the
OBJECT_NAME field of the USER_OBJECTS view I am able to find 3 of the 5 files in the meta-inf directory, registered and valid in the database:

meta-inf/MANIFEST.MF
meta-inf/javamail.charset.map
meta-inf/mailcap

However the javamail.default.providers and javamail.default.address is being loaded and registered under the following names:

/6bdfd3bc_javamaildefaultprovi
/45f87eff_javamaildefaultaddre

Since these are resource type files rather than class files, Oracle must some how be registering them differently!? I have also tried loading these 2 files individually and they are still loaded the same way. Please help if you have any ideas as to what might be going on here????

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 15:23:24 CST