how to display images from any drive in oracle froms and i want to save the images in database als [message #529844] |
Thu, 03 November 2011 05:44 |
meena.g
Messages: 14 Registered: February 2010 Location: Hyderabad (A.P)
|
Junior Member |
|
|
I am using oracle forms 10g .I am trying to display employees images from c drive in form and inserting images in database through oracle froms but I am getting errors.please can you help me on that...
by this code iam getting error like this
when-mouse-click trigger on image item:
DECLARE
gif_image_dir VARCHAR2(80) := 'c:\temp\';
photo_filename VARCHAR2(80);
BEGIN
photo_filename := gif_image_dir||'*.tiff';
READ_IMAGE_FILE(photo_filename, 'tiff', 'BLOCK2.im1');
END;
error :FRM-47109:cannot locate image file c:\temp\*.tiff like this
I tried one more method ...please find the below code:
when-mouse-click trigger on image item
declare
file_path varchar2(1000);
begin
file_path := get_file_name('C:\',file_filter =>'All Files(*.*)|*.*|');
READ_IMAGE_FILE (file_path , 'jpg' , 'CALC_C.IM' );
end;
error :FRM-47105:no images name specified.
3rd method :when-mouse-click trigger on image item
declare
file_path varchar2(1000);
a varchar2(1000);
begin
a:='C:\employee image\';
File_path := get_file_name(a,file_filter =>'All Files(*.*)|*.*|');
READ_IMAGE_FILE (a||'*.jpg' , 'jpg' , 'emp.image' );
end;
FRM-47109:FRM-47109:cannot locate image file c:\food picture for biff\*.jpg
so please any one can help me how to do ....
[Updated on: Fri, 04 November 2011 04:59] Report message to a moderator
|
|
|