Send E-Mail with attachment from HTML DB
481088Jul 20 2006 — edited Jul 25 2006Hello,
i want to sent E-Mails with attachments from HTML DB.
My intention is, that the user can mail a report to some people. Therefor I guess it is not possible that the report can be displayed in the body of the message...
If it is possible, please tell me how!
So I think the best way to send a report as an attachment is, to store the report as a document in the database and after that to send it as an attachement.
But my problem is, that the htmldb_mail package cannot send attachments....
Or is it wrong?
I only find that the utl_mail package can send mails with attachments. But I cannot use this package inside the HTML DB...
So my idea is, to create a stored procedure inside the database, which send the mail with attachments and which is called from an application.
My Question is, if my idea is possible and how i can realize it?
If you have a better idea of sending reports inside a mail, please let me know!
Thank you very much!
Tim