I hope somebody can help. I did open an iTar with Metalink but they are as slow as usual.
Following the instruction in Note 120994.1, I came successfully to the end where I run the test block:
Who knows how to get rid of that error?Code:
SQL> BEGIN
2 :ErrorStatus := SendMailJPkg.SendMail(
3 SMTPServerName => 'XX.XX.X.XX',
4 Sender => '[email protected]',
5 Recipient => '[email protected]'
6 CcRecipient => '',
7 BccRecipient => '',
8 Subject => 'This is the subject line: Test JavaMail',
9 Body => 'This is the body: Hello, this is a test' ||
10 SendMailJPkg.EOL || 'that spans 2 lines',
11 ErrorMessage => :ErrorMessage,
12 Attachments => SendMailJPkg.ATTACHMENTS_LIST(
13 'c:\junk\40.sql',
14 'c:\junk\sal.sql'
15 )
16 );
17 END;
18 /
PL/SQL procedure successfully completed.
SQL> print
ERRORMESSAGE
---------------------------------------------------------------------------------------
javax.mail.NoSuchProviderException: No provider for Address type: rfc822
ERRORSTATUS
-----------
1
SQL>
I found Doc ID: 25784.999 where it says that mail.jar should be first decompressed and the uncompressed but it didn't help. Could it be CLASSPATH?
