| FRM-47109: Cannot locate image file in form oracle 10G [message #435674] |
Thu, 17 December 2009 05:35  |
martjosh
Messages: 13
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  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
