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 .
] 
Blog
Search
Help
Members
Register
Login
Home
