7 Replies Latest reply on Oct 2, 2013 1:17 AM by sus2013

    Email an image file via APEX MAIL and PL/SQL




      I would lile to send an APEX CHART image file ( saved in the local directory P:\test.png ) to other users via APEX MAIL.   Users don't have access to the drive P at all.


      Would the following plan work ( in Oracle 11gR2 and APEX 4.2 ) ?  Any other advice ?


      (1) create an Oracle directory ( for storing the image files )

      (2) create an Oracle table with BLOB column to store the image data

      (3) create an Oracle PL/SQL program to read data from the private CHART image file to the Oracle table

      (4) Use APEX_MAIL.add_attachment to send out the image data from the Oracle table