| GET_FILE_NAME functionality [message #446453] |
Mon, 08 March 2010 09:39  |
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
|
Junior Member |
|
|
Hi all,
can anyone help to solve the issue....
I have my forms application working on both windows and Unix platform. When i am using GET_FILE_NAME ( ), it is working fine in Windows based application but the same is not working in Unix based application... What might be the issue?
Thanks
Arun
|
|
|
|
|
|
| Re: GET_FILE_NAME functionality [message #446529 is a reply to message #446454] |
Tue, 09 March 2010 02:50  |
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
|
Junior Member |
|
|
Hi, Pls chk it..
The following code works fine in windows based application but not in Unix based application.
DECLARE
lv_dirname VARCHAR2(255);
lv_filename VARCHAR2(255);
BEGIN
tool_env.getvar('DEMO20', lv_dirname);
lv_dirname := 'c:\';
lv_filename := get_file_name(lv_dirname, NULL, 'List (*.csv)|*.csv|' );
IF lv_filename IS NOT NULL THEN
:FILENAME := lv_filename;
END IF;
--go_field('LIST_NM');
END
When running, opens c: of server in windows based but nothing in Unix based..
Do we have any different builtin function to get the same functionality in Unix based application?
Thanks
Arun
|
|
|
|
|
|
|
|
| Re: GET_FILE_NAME functionality [message #446738 is a reply to message #446533] |
Wed, 10 March 2010 03:57 |
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
|
Junior Member |
|
|
Hi
Even i tried with the Unix path also as following:
DECLARE
lv_dirname VARCHAR2(255);
lv_filename VARCHAR2(255);
BEGIN
tool_env.getvar('DEMO20', lv_dirname);
lv_dirname := '/iasapp01/relwhapp/forms';
lv_filename := get_file_name(lv_dirname, NULL, 'arun_data (*.csv)|*.csv|' );
IF lv_filename IS NOT NULL THEN
:FILENAME := lv_filename;
END IF;
--go_field('LIST_NM');
END;
Nothing is happening when i run it...
Pls let me know the soln..
|
|
|
|
|
|
|
|
|
|
| Re: GET_FILE_NAME functionality [message #480805 is a reply to message #480510] |
Wed, 27 October 2010 06:11 |
mego
Messages: 2
Registered: October 2010
Location: CAIRO
|
Junior Member |
|
|
I appreciate your effort, but the problem is I have a 6i application which includes a form works properly and I can browse and select an image file using
the GET_FILE_NAME directly (with no need to use any TEXT_IO functions because I just browse and select an image file), when I compiled this form to 10g with no compilation errors and run it the function returns null value for the filename.
- I checked the on-line help before trying to ask but the GET_FILE_NAME only appear in the TEXT_IO example.
- I checked the FORM_PATH in the regedit to ensure that the images folder is reached.
- I wrote the images path explicitly in the GET_FILE_NAME but no way.
- finally I searched the Internet to reach here.
- The code is very simple only to browse and select a file:
DECLARE
FNAME VARCHAR2(200);
BEGIN
FNAME := GET_FILE_NAME('PIC Files (*.GIF)|*.GIF|');
IF FNAME IS NOT NULL THEN
READ_IMAGE_FILE(FNAME,'GIF','COMPANY.LOGO');
:LOGO_PATH := FNAME;
IF NOT FORM_SUCCESS THEN
MESSAGE('NO IMAGE FOUND');
END IF;
IMAGE_ZOOM('COMPANY.LOGO',ADJUST_TO_FIT);
ELSE
SMS('NO FILES WERE BROWSED');
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
SMS('NO IMAGE WAS SELECTED');
WHEN OTHERS THEN
SMS('PLEASE CONTACT YOUR ADMINISTRATOR');
END;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
