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:




      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.