Search This Blog

Monday, July 10, 2017

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

It is very easy to upload a image in form and show it in form. Here I give the sequence of task to do.

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.
Now upload image and see it on your report.
Thank You.

No comments:

Post a Comment

Check Difference Between Two Database Objects

Step-1. Create Two DBLINK to connect with Two Database then Step-2. define logindb= DBLINKONE define remotedb= DBLINKTWO define schema_name=...