HOW TO CONFIGURE WEBUTIL IN ORACLE FORMS 10G

 I'm going to demonstrate in a straightforward manner how to setup Oracle WebUtil Package to work with Oracle forms 10g.

Configuring WebUtil:

• Click to download Package.
• Both RAR files should be extracted to some directory.
• Copy
• File frmwebutil.jar
    From folder: webutil_106\webutil_106\java  To: $ORACLE_HOME/forms/java
  
    File: jacob.jar 
    From folder: jacob_18  To: $ORACLE_HOME/forms/java
  
    File: d2kwut60.dll, JNIsharedstubs.dll
    From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil
  
    File: jacob.dll
   From folder: jacob_18 To: $ORACLE_HOME/forms/webutil
  
    File: forms_base_ie.js, forms_ie.js
  - From folder: webutil_106\webutil_106\java To: $ORACLE_HOME/forms/java
  
   File: webutil.olb, webutil.pll and create_webutil_db.sql
   From folder: webutil_106\webutil_106 To: $ORACLE_HOME/forms
  
   File: webutilbase.htm, webutiljini.htm, webutiljpi.htm and webutil.cfg
  - From folder: webutil_106\webutil_106\server To: $ORACLE_HOME/forms/server
  
  File: sign_webutil.bat
  - From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil

• In $ORACLE_HOME/forms/server/formsweb.cfg file
• Make the necessary changes to the entries below.

# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar 

if you use JRE plugin then this line also required
archive=frmall_jinit.jar,frmwebutil.jar,jacob.jar 

[webutil]
WebUtilArchive=/forms/java/frmwebutil.jar,/forms/java/jacob.jar

<if you use JRE plugin then this line also required>

Replace baseHTMLjinitiator=webutiljini.htm with baseHTMLjinitiator=webutiljpi.htm 

•  In $ORACLE_HOME/forms/server/default.env file change the following entries

             FORMS_PATH=C:\YourOracle_Home\forms;C:\YourOracle_home\forms\webutil

              # webutil config file path
              WEBUTIL_CONFIG=C:\YourOracle_Home\forms\server\webutil.cfg

            Add frmwebutil.jar, jacob.jar into Classpath  

CLASSPATH=C:\YourOracle_Home\forms\java\frmwebutil.jar;C:\YourOracle_Home\forms\java\jacob.jar

•  Sign Webutil JAR files by running these following commands Make sure Form Builder is Closed

For Example :

        C:\>set PATH=D:\<Oracle_Home>\jdk\bin

        C:\>cd <Oracle_Home>\forms\webutil
        C:\<Oracle_Home>\forms\webutil>sign_webutil.bat C:\<Oracle_Home>\forms\java\frmwebutil.jar

        C:\<Oracle_Home>\forms\webutil>sign_webutil.bat C:\<Oracle_Home>\forms\java\jacob.jar

• This will kick off a procedure that will culminate with a message. 1 file transferred successfully

Database configuration:

• Connect via Scott or your User if you like.
• You may use SQLPLUS or any other tool to run the script located at $ORACLE HOME/forms/create webutil db.sql.

Setting up Form Builder:

• Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
• Use the "File" menu to save the file under an alternative name, such as "WebUtil lib," and then rename the file.
• Create the new PLL file by compiling the existing one.
• Attached a new file to your form with the name Webutil lib.pll and selected the Remove Path option. YES.
• Launch the builder and go to the WebUtil.olb file's Object group. Then, either copy it or subclass it into your form.
• Now it's time to assemble and execute your form.

Note:

The first time you use these libraries, the browser will ask you to certify them. Select the ALWAYS certify option. Verify that the frmwebtul.jar and jacob.jar files have been loaded properly by clicking the Java Console icon located on the task bar.

• Click the Browse button on the form, then choose Datafile.txt, and then click the Open button... It is going to load a text file into the Data Block.

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.