Mail with attchments from PL/SQL

[julian]

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:

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>

Who knows how to get rid of that error?

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?

[pipo]

what is your CLASSPATH set to ??
are you using WebLogic ?

[julian]

Originally posted by pipo
what is your CLASSPATH set to ??
are you using WebLogic ?

CLASSPATH is set to files (with complete paths) mail.jar and activation.jar No, I am not using WebLogic.

[pipo]

maybe found one answer for you, you could try this :

1) use java mail framework 1.1.3
2) jar xf mail.jar (uncompress mail.jar)
3) tar cvf0 mail.jar com javax meta-inf (create uncompressed jar)
4) upload new mail.jar

[Edited by pipo on 01-25-2002 at 10:44 AM]

[julian]

Originally posted by pipo
maybe found one answer for you, you could try this :

1) use java mail framework 1.1.3
2) jar xf mail.jar (uncompress mail.jar)
3) tar cvf0 mail.jar com javax meta-inf (create uncompressed jar)
4) upload new mail.jar

[Edited by pipo on 01-25-2002 at 10:44 AM]

Thanks Pipo, I did that yesterday. It did not help. After uploading the mail.jar I still get two errors : Value cannot fit into a column, I assume that this might be the possible reason.