asked on

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;

ASKER CERTIFIED SOLUTION

Helena Marková

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Godfrey Tsamaesi

ASKER

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á

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

Godfrey Tsamaesi

ASKER

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

SOLUTION

Helena Marková

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Godfrey Tsamaesi

ASKER

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.

SOLUTION

Helena Marková

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Helena Marková

Webutill library is the solution.