1 Reply Latest reply: Feb 22, 2013 6:17 AM by Nick B RSS

    pl/sql procedure to send emails with attachments

    992429
      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
        • 1. Re: pl/sql procedure to send emails with attachments
          Nick B
          I think you are not obliged to use UTL_SMTP in this situation. Setting the security group id in your PL/SQL code allows you to use the easy to use APEX_MAIL package.
          The following article explains how you set the security group id: http://riyazmsm.blogspot.be/2010/09/apexmail-package.html
          Official APEX_MAIL documentation: http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35127/apex_mail.htm