Home » Developer & Programmer » Forms » how to display images from any drive in oracle froms and i want to save the images in database als
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

Previous Topic: Procedure
Next Topic: how to default where condition
Goto Forum:
  


Current Time: Thu Sep 12 18:51:21 CDT 2024