We help IT Professionals succeed at work.

oracle forms, open  dialog box

Godfrey Tsamaesi
on
532 Views
Last Modified: 2018-02-26
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;
Comment
Watch Question

programmer-analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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.
Helena Markováprogrammer-analyst
CERTIFIED EXPERT

Commented:
I don't see screen with error. Have you attached webutil.pll library to your form without path to it ?

Author

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
Helena Markováprogrammer-analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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.
Helena Markováprogrammer-analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Helena Markováprogrammer-analyst
CERTIFIED EXPERT

Commented:
Webutill library is the solution.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.