OraFAQ Forum: Forms » image / BLOB

Home » Developer & Programmer » Forms » image / BLOB_TABLE (oracle 10g, form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

image / BLOB_TABLE [message #500431]

Mon, 21 March 2011 04:09

devendrapal26
Messages: 15
Registered: March 2011
Location: india

Junior Member

[MERGED by LF]

oracle 10f, FORM 6i
when i simply rum my programe its working properly, but when run on web its "browse button" not working, my coding on browse button is :-----

declare
dirname varchar2(255);
v_filename varchar2(255);
begin
tool_env.getvar('D:\', dirname);
dirname := dirname || '\bin\bmp';
v_filename := get_file_name(dirname,NULL,
'All Files (*.*)|*.*|' /*||
'JPEG Files (*.jpg)|*.jpg|' ||
'Bitmap Files (*.bmp)|*.bmp|' ||
'TIFF Files (*.tif)|*.tif|' ||
'CompuServe Files (*.gif)|*.gif|' ||
'PC Paintbrush Files (*.pcx)|*.pcx|'*/ );
:LN_BROWSE_PATH.VC_FILE_PATH:=v_filename;
if v_filename is not null then
read_image_file(v_filename,'ANY','LN_BROWSE_PATH.LG_FILE_IMAGE');
end if;
end;

please give me suggestion for, how can i run my programe on web.....

[Updated on: Tue, 22 March 2011 06:08] by Moderator

Report message to a moderator

Re: image [message #500433 is a reply to message #500431]

Mon, 21 March 2011 04:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does "it is not working" mean? Any error? If so, which one?

Could it be that directory you are trying to browse is not the one you are expecting (i.e. you see it from Forms Builder as it is on your local hard disk, but you can't see it when form is ran from the application server (and directory doesn't exist on iAS))?

Report message to a moderator

Re: image [message #500440 is a reply to message #500433]

Mon, 21 March 2011 05:49

devendrapal26
Messages: 15
Registered: March 2011
Location: india

Junior Member

thks for reply

its not working means , that code is not give any error, when i simply run this form & i press the browse button i am get a dialog box for image selection, but when i run this programe on web its not give any error, & not open a dialog box.....

Report message to a moderator

BLOB_TABLE [message #500585 is a reply to message #500431]

Tue, 22 March 2011 05:49

devendrapal26
Messages: 15
Registered: March 2011
Location: india

Junior Member

oracle 10f, FORM 6i
when i simply rum my programe its working properly, but when run on web its "browse button" not working, my coding on browse button is :-----

declare
dirname varchar2(255);
v_filename varchar2(255);
begin
tool_env.getvar('D:\', dirname);
dirname := dirname || '\bin\bmp';
v_filename := get_file_name(dirname,NULL,
'All Files (*.*)|*.*|' /*||
'JPEG Files (*.jpg)|*.jpg|' ||
'Bitmap Files (*.bmp)|*.bmp|' ||
'TIFF Files (*.tif)|*.tif|' ||
'CompuServe Files (*.gif)|*.gif|' ||
'PC Paintbrush Files (*.pcx)|*.pcx|'*/ );
:LN_BROWSE_PATH.VC_FILE_PATH:=v_filename;
if v_filename is not null then
read_image_file(v_filename,'ANY','LN_BROWSE_PATH.LG_FILE_image');
end if;
end;

that code is not give any error, when i simply run this form & i press the browse button i am get a dialog box for image selection, but when i run this programe on web its not give any error, & not open a dialog box.....

Attachment: Browser.fmb
(Size: 176.00KB, Downloaded 1062 times)

Report message to a moderator

Re: image [message #500595 is a reply to message #500433]

Tue, 22 March 2011 06:06

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no use in repeating the same code twice. Besides, would you, please, learn how to properly format code you post? It would make it easier to read.

There's nothing I'd like to add to my previous message.

Report message to a moderator