Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » display image in apex 5 (Oracle Db 11G & Apex 5)
display image in apex 5 [message #642021] Sun, 30 August 2015 12:12 Go to next message
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
Hi all

I have a table with a "blob" column for person's picture;

i create an interactive report with form with wizard .

i use
 select Ma_id ,ma_name, 
dbms_lob.getlength("MA_IMAGE") ma_image
from dt_persons 

when i run my report i see "download" link in image colume and that work ....

when i use
 select Ma_id ,ma_name, 

       CASE WHEN nvl(dbms_lob.getlength("MA_IMAGE"),0)=0 THEN null
       ELSE    '<img alt="'||apex_escape.html_attribute("MA_FAMIL")
              ||'" title="' ||apex_escape.html_attribute("MA_FAMIL")
              ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
              ||'src="'||apex_util.get_blob_file_src('P3_MA_IMAGE',MA_IDNO)||'" height="75" width="75" />' 
       END   img 
from dt_persons 

that P3 is my Page for create record and it work and i can create my data records .
but when i run report in colume "img" i see this text : " img ..... 3 line of number and chars.... " that in my SQL !

please help me .
Re: display image in apex 5 [message #642062 is a reply to message #642021] Tue, 01 September 2015 09:38 Go to previous message
Messages: 11
Registered: August 2015
Location: London
Junior Member
I'm not sure if I understand correctly, if the image was uploaded in APEX then it will have a long path of numbers and characters for the 'src' value of the 'img'.

[Updated on: Tue, 01 September 2015 09:39]

Report message to a moderator

Previous Topic: run PLSQL procedure When Button Press
Next Topic: ORDS Glassfish Tomcat
Goto Forum:

Current Time: Sat May 18 08:39:27 CDT 2024