Mail with attchments from PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Mail with attchments from PL/SQL

  1. #1
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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:

    Code:
    SQL> BEGIN
      2     :ErrorStatus := SendMailJPkg.SendMail(
      3                  SMTPServerName => 'XX.XX.X.XX',
      4                  Sender    => 'test@server.com',
      5                  Recipient => 'test@server.com'
      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?


  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    what is your CLASSPATH set to ??
    are you using WebLogic ?

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.


  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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]

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width