10 Replies Latest reply: Apr 28, 2014 12:56 AM by Ramani_apex RSS

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

    Laury

      Hi,

       

      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:

       

      select

          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)

      from

          application_pictures

      where

          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