SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pl/sql procedure to send emails with attachments

992429Feb 22 2013 — edited Mar 5 2013

Hi,

Daily i run some queries related to my application manually and mail those reports in the form of excel to my customers. Now i would like to automate this process.
I have got some idea that i have to use UTL_SMTP in my procedure and DBMS_Scheduler for this requirement. I am seeking for a help to complete this requirement by providing me some links or sample pl/sql code.

Additional Info : Database : Oracle11g

Thanks in advance!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2013

Added on Feb 22 2013

#pl-sql, #plsql

5 comments

5,424 views