Send mail with attachment from a Module in Forms 10g
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.