Saturday, January 5, 2019

How to upload Image from Form and Show it in Report on Oracle apex 18.2


1. First add a column for IMAGE  with BLOB type.
2. Create a report and it's data inserting form where there will be a FILE BROWSER type option for       Image.
3. Select on REPORT then go to Properties then Code Editor - SQL Query
4. Then Add [ dbms_lob.getlength(Column Name) img ] respective of IMAGE column.
5. And finally select on IMAGE column then goto properties and change type as DISPLAY IMAGE

at the end save and run.

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...