Table Code:
========
create table image_table(
p_id number,
p_name varchar2(20),
p_pic blob,
primary key(p_id));
Sequence Code:
===========
create sequence hr_image_seq
start with 100
increment by 1
Report Query:
==========
select p_id,p_name,
decode (nvl(dbms_lob.getlength('p_pic'),0),0,null,
'<img src=" ' ||apex_util.get_blob_file_src('P4_P_PIC',p_id) || ' " width="100"/>') "image"
from image_table
========
create table image_table(
p_id number,
p_name varchar2(20),
p_pic blob,
primary key(p_id));
Sequence Code:
===========
create sequence hr_image_seq
start with 100
increment by 1
Report Query:
==========
select p_id,p_name,
decode (nvl(dbms_lob.getlength('p_pic'),0),0,null,
'<img src=" ' ||apex_util.get_blob_file_src('P4_P_PIC',p_id) || ' " width="100"/>') "image"
from image_table
i work for display image step by step but the image don't appear Please help me..
ReplyDeleteI have a video in my Youtube channel.Please see that I hope you will be capable to solve that.Otherwise please mail:baizeedrony@gmail.com.
Deletethaks
Baizeed Rony
I got error as like this in output
ReplyDeleteimg src= " "width="100"
How can i resolve this..
change the image field type present graph
Delete
ReplyDeletecheck field name correct "P4_P_PIC" from entry forms