3 Replies Latest reply on Jun 20, 2017 12:21 PM by Shaun

    BLOB image sizing - APEX 5

    Ed Heaton

      Hi all,

       

      I have successfully managed to get Oracle APEX to display an image using the following method:

       

      select

      pic_id,

      dbms_lob.getlength(blob_data) image

      from pics;

       

      The image displays but I want to somehow reduce the size (Height/Width) by a specific percentage (eg 90%).

       

      Is there any HTML I can add to the SQL query that can achieve this?

       

      I have attempted to get the following method to work here but with no luck:

       

      Engineering Business Intelligence: APEX: Working with Images from Oracle BLOB fields

       

      Any advice would be greatly appreciated.  I am a DBA by trade so my APEX/HTML skills leave much to be desired.

       

      Cheers

       

      Ed