This discussion is archived
1 Reply Latest reply: Feb 22, 2013 4:17 AM by Nick B RSS

pl/sql procedure to send emails with attachments

992429 Newbie
Currently Being Moderated
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!!

Edited by: menaka2891989 on Feb 22, 2013 4:12 PM

Edited by: menaka2891989 on Feb 22, 2013 4:16 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points