Skip to Main Content

Send mail with attachment from a Module in Forms 10g

Hafed BenteftifaOct 20 2008 — edited Oct 21 2008
Hello,

An interesting email with attachments case if someone has a better solution.

Form module is called. Let's call it INVOICE_MOD. User enters a new invoice and then can either choose to PRINT or MAIL the invoice.
If user clicks on PRINT button, a PDF is generated (thru report server 10g) and user can either physically print the invoice or save the invoice on his desktop.
If user clicks on MAIL button, an email should be sent to client. The email should contain the following:
-From, to, subject, body and the invoice attached as PDF.

Please make not of the last requirement, that is the invoice that was created should be attached to the email as PDF.

Restriction: we can not store anything on the application server although we can manipulate the reports server cache.

Solution that was implemented makes use of BLOBs where the pdf is stored in a table before being sent.
See Metalink NOTE:330146.1 and 70110.1.
http://www.dba-oracle.com/t_email_mailing_messages_plsql.htm also has some interesting implementations.
I also went thru the JAVAMAIL bean but this requires attachments on the client side.

Thanks for any input.

Hafed
www.degenio.com
Comments
Post Details
Added on Oct 20 2008
3 comments
555 views