Hi Sir,
How to display image in interactive Grid report
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
hi your blob column will store on db or it will come from path
Hi Sir,
This is my table once the file is uploaded in db it should show the image in Interactive Grid
Sir is it possible
select “ID”,”NAME”,sys.dbms_lob.getlength(“PIC”)”PIC”,”MIMETYPE”,”FILENAME”,
decode(nvl(dbms_lob.getlength(PIC),0),0,null,
‘<img alt=”‘||apex_escape.html_attribute(NAME)||'” title=”‘||apex_escape.html_attribute(NAME)
||'” style=”border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;” ‘
||’src=”‘||apex_util.get_blob_file_src(‘P14_PIC’,ID)||'” height=”75″ width=”75″ />’) detail_img
from “INFO”
then change tyle of detail_image to percent grap
Why the page item P14_PIC specified in the query? What is the purpose?
When giving the answers please explain well.
Column IMAGE which is of data type 9 can not be converted to VARCHAR2!
i am getting error while try to show image in IG Report