10 Replies Latest reply on Apr 28, 2014 5:56 AM by Ramani_apex

    Display a single BLOB image stored in  table in an HTML region




      I which to display a BLOB file initially stored in a table (in my case an image or jpg picture) in an HTML region in APEX (APEX 4.2).


      My BLOB is extracted as the following:



          picture_id, => the unique value ID of the image

          stored_picture, => the BLOB image

          mimetype, -> the type for the image, here, jpg

          filename => the name of the image (this is just a text file)




          picture_id = VALUE_1;


      What kind of HTML region should I use in APEX?


      - HTML text

      - HTML Escape Special Character

      - Dynamic PL/SQL


      Can someone exlain me how this can be achieved?


      Thanks by advance for any tip.


      Kind Regards