Home » Developer & Programmer » Forms » FRM-47109: Cannot locate image file in form oracle 10G
FRM-47109: Cannot locate image file in form oracle 10G [message #435674] Thu, 17 December 2009 05:35 Go to next message
martjosh
Messages: 7
Registered: December 2009
Location: Riyadh
Junior Member
Hi Everyone,

I find it hard to solve this problem. Hope someone could help me to this. below is my scripts for image loading from file to form and save it to database.it is located in when-button-pressed trigger.

Declare
v_file_name VARCHAR2(255);
v_msg varchar2(100);
BEGIN

--:System.Message_Level := '25';
v_file_name := CLIENT_GET_FILE_NAME('\',null,'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');

IF v_file_name IS NOT NULL
THEN
CLIENT_IMAGE.READ_IMAGE_FILE(v_file_name,null,'CONTRACT_DOCS.SUPPORT_DOC');
v_msg := msgBox(v_file_name);
END IF;
EXCEPTION
when others then
Set_Alert_Property('MSG_ALERT',Alert_Message_Text,ERROR_TEXT);
RAISE FORM_TRIGGER_FAILURE;

END;

thanks.

Regards
Re: FRM-47109: Cannot locate image file in form oracle 10G [message #435823 is a reply to message #435674] Fri, 18 December 2009 03:38 Go to previous messageGo to next message
beginnerHere
Messages: 55
Registered: October 2009
Member
hi,

create a table with a blob datatype column, use the forms datablock wizard to create a form from that table. the blob column will ensure that on the form it shows an image item mapped to the column. place a button that reads the image from the system into the image item. behind the button write:

begin
	read_image_file('c:\1.gif', 'GIF', 'BLOCK_NAME.photo');
end;


where "C:\1.gif" is the full path of the image file and "photo" is the name of the image item created on the canvas by the datablock wizard.

commit the form. the image gets saved in the database. done.

hope it helps
Re: FRM-47109: Cannot locate image file in form oracle 10G [message #435861 is a reply to message #435823] Fri, 18 December 2009 08:06 Go to previous messageGo to next message
martjosh
Messages: 7
Registered: December 2009
Location: Riyadh
Junior Member
thanks for the information.
Re: FRM-47109: Cannot locate image file in form oracle 10G [message #588476 is a reply to message #435674] Wed, 26 June 2013 02:49 Go to previous message
beimage
Messages: 6
Registered: May 2013
Junior Member
i was having the same problem, thanks
Previous Topic: Error WUF-201 and WUF-200, when open or read file
Next Topic: Open Tiff Images
Goto Forum:
  


Current Time: Sat Sep 20 09:43:08 CDT 2014

Total time taken to generate the page: 0.11962 seconds