Oracle Forms

hi am trying to have open dialog in form 11gR2, i have config webutil

i follow this

Goal: How to Configure Webutil Library in Fusion Middleware Forms 11g (11.1.2.0).

The Webutil utility is largely configured in your 11g Forms installation. However, there are some additional steps you will need to accomplish in order to make it work properly.

Additional Webutil components maybe needed in order to configure Webutil for development purposes. These Components are:

1- Jacob Package 1.14.3 for (11.1.2.0)

You can found this package on mentioned below URL:

Download

In this package, there are three files:

1- Jacob.jar

2- jacob-1.14.3-x64.dll

3- jacob-1.14.3-x86.dll

Before Using the Above mentioned files, Follow the steps mentioned below to create Webutil user in Database.

1- Login from SYS

2- CREATE USER Webutil IDENTIFIED BY Webutil (Already Created in 11g)

3- Grant connect, resource to Webutil

4- Connect Webutil/Webutil

5- Run create_webutil_db.sql from /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/

6- Create public synonym webutil_db for webutil.webutil_db;

7- Connect sys as sysdba

8- Grant execute on webutil_db to public;

Now Place the Jacob.jar into /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java Directory.

Place Jacob-1.14.3-x64.dll into /weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win64 Directory.

Place Jacob-1.14.3-x86.dll into /weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win32 Directory.

Create a backup of sign_webutil.sh with different name, this file can be found in

/Weblogic/weblogic_10.3/Middleware/asinst_1/bin Directory

Open sign_webutil.sh file in notepad and search for <Your KEYSTORE password> line. Replace it with “welcome1”. Similarly search for < Your private key password > line and replace it with “welcome1”. Save the file to the same directory after Editing.

Now run the Following command to sign both files with Jacob.jar and frmwebutil.jar files

[oracle@earth bin] $ ./sign_webutil.sh /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/Jacob.jar

[oracle@earth bin] $ ./sign_webutil.sh /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmwebutil.jar

After Jar Signing, Go to Browser and type the following command to open Oracle Fusion Middleware Console.

http://userid=username/password@sid:7001/em

Add /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmall.jar path into CLASSPATH Variable Default.env

Or

Add Manually By using following command:

[oracle@earth bin] $ vi .bash_profile

Add /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmall.jar path into CLASSPATH variable in bash_profile.

Regenerate the webutil.pll using following command:

[oracle@earth bin] $ Frmcmp.sh module=webutil.pll module_type=library userid=username/password@sid compile_all=yes

Open & Edit the Following Parameters in formsweb.cfg, it can be found in:

/weblogic/weblogic_10.3/Middleware/user_projects/domains/webforms_domain/config/fmwconfig/servers/WLS_FORMS/

applications/formsapp_11.1.2/config Directory.

Archive= frmall.jar, frmwebutil.jar

Modification in [Webutil] Section:

WebUtilArchive=frmwebutil.jar, jacob.jar

Archive=frmall.jar, frmwebutil.jar, jacob.jar

Save the formsweb.cfg after editing.

Install a VNC Client on Windows to create Linux client session on Windows because linux do not support drag & Drop functions in Oracle Form 11g.

Open Oracle forms builder 11g on Linux client, Create a new form,a new block & a canvas.

after that attach webutil.pll on Navigator—> Attached Libraries in Forms that you have compiled earlier.

Attach Webutil.olb in Object Libraries in oracle Forms.

Open WebUtil.olb file Object group in builder and copy or subclass it into your form.

Create a Button (B1) and a text field (P1) on Already created canvas.

Copy & paste the following Code in When Button Pressed Trigger.

Declare

v_file varchar2(500);

Begin

v_file := CLIENT_GET_FILE_NAME (directory_name => 'C:\Forms\Reports',

                           file\_name       => NULL,

                           file\_filter     => NULL,

                           message         => 'Open a file',

                           dialog\_type     => OPEN\_FILE);

   :P1:=v\_file;

End;

Compile & Save the form again.

Run the Form and browse any file in your Client PC in order to check the Webutil proper functionality.

Note: Browser will ask to certify these libraries first time Choose ALWAYS certify. Check Java Console icon on the task bar and see frmwebtul.jar and jacob.jar are loaded successfully.