oracle forms, open dialog box

I have used GET_FILE_NAME(File_Filter=> 'All Files |*.*|'); in my button to open a dialog but nothing is happening.

DECLARE
      filename VARCHAR2(2000);
BEGIN
    filename := GET_FILE_NAME(File_Filter=> 'All Files |*.*|');
end;
Godfrey TsamaesiAsked:
Who is Participating?
 
Helena MarkováConnect With a Mentor programmer-analystCommented:
In web forms you have to use webutil.pll library. There is CLIENT_GET_FILE_NAME function there. In the Forms on-line help you can read more in a WebUtil User's Guide.
As an addition-GET_FILE_NAME opens dialog in application server, so you cannot see it on your PC.
0
 
Godfrey TsamaesiAuthor Commented:
Thanks Helena for your reply, i did try to use CLIENT_GET_FILE_NAME however i  get error 'CLIENT_GET_FILE_NAME must be declared ' when  i compile my form. See screen shot attached.
0
 
Helena Markováprogrammer-analystCommented:
I don't see screen with error. Have you attached webutil.pll library to your form without path to it ?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Godfrey TsamaesiAuthor Commented:
Hi below is the peace of code i have. Yes i attached webutil.pll library to form without path to it.

Declare
      w_file_name varchar2(2000);
Begin
      w_file_name := CLIENT_GET_FILE_NAME ('D1', null, 'All Files (*.*)|*.*|',null,open_file,true);
                                    
End;
Forms_11g.PNG
Forms_11g.PNG
0
 
Helena MarkováConnect With a Mentor programmer-analystCommented:
Is webutil.pll in the same directory as *.fmb files are ?
0
 
Godfrey TsamaesiAuthor Commented:
I  have put them i'm getting a different error when i deploy my forms to the server '
Compilation errors have occurred.' but when i compile locally there are no errors.
0
 
Helena MarkováConnect With a Mentor programmer-analystCommented:
Also on server put webutil.pll to the same diractory as *.fmb files.If you use some *.olb libraries put them to that directory, too.
0
 
Helena Markováprogrammer-analystCommented:
Webutill library is the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.