April 27, 2008 at 8:04 pm
Need to send an email with attachments to the user. The attachment contains information/data from Oracle server. Not sure whether Oracle has capability to do this. If use SQL Server to send out email, I am thinking to make a linked server to Oracle and retrieve data via linked server, then send out email.
Is it the right approach? Or is there any better way to do it?
April 28, 2008 at 8:23 am
Yes. You can send mails from oracle database. I think this option available from Oracle 8i. Please refer the link which clearly explains how to send mails from OracleDB.
http://www.samoratech.com/Topicofinterest/swHowtoSendMail.htm
And say thanks to "Sameer Wadhwa" - The owner of the above article 🙂
April 28, 2008 at 8:38 am
Great info. Thank you.
I am looking for sending email with attachments/reports rather than email message. As per the article, “If you want to send mail with attachment , you can send it by using java procedure . There is no method available as yet for it by UTL_SMTP package.”
Is it the limitation?
April 28, 2008 at 8:49 am
Check this link...
http://www.orafaq.com/wiki/Send_mail_from_PL/SQL#Send_mail_with_UTL_SMTP_-_with_attachments
Learn abt UTL_MAIL @ http://www.psoug.org/reference/utl_mail.html
Learn abt UTL_SMTP @ http://www.psoug.org/reference/utl_smtp.html
Hope this helps... 🙂
April 28, 2008 at 9:15 am
Really helps. Thank you very much!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply