blob insert & display pls hlp [message #83839] |
Thu, 18 December 2003 07:14 |
Jasmine
Messages: 23 Registered: December 2000
|
Junior Member |
|
|
hi
i am trying to insert blob field(a jpeg image ) thru forms
I am getting error
Frm -47105 no image name specified
The get_file_name in not working or the dialog bos is not opening
How to get the flow of the program as we debugger in vc++ any tools
To get the flow of program
How can we specify the image name
declare
filename varchar2(200);
BEGIN
:system.message_level := '25';
filename := GET_FILE_NAME('c:jas',null, 'Jpeg Images (jpg, jpeg)|*.jp*g|','save',OPEN_FILE,TRUE);
READ_IMAGE_FILE( filename,'jpg','img.image');
if not form_success then
message('Not working proeprly');
raise form_trigger_failure;
end if;
END;
Then after I wrote this code
This gives error
Frm -47109 cannot locate file
But the file's in same location
How can we give in double quotes ,single or anything else
When I am trying both ways it giving error cannot locate
Then I getting error
BEGIN
READ_IMAGE_FILE( :img.loc,'jpg','img.image');
if not form_success then
message('Not working proeprly');
raise form_trigger_failure;
end if;
END;
Pls hlp
jasmine
|
|
|