Webutil For Forms 10G

How to configure Webutil in Oracle Forms 10G

I'm going to show, How to configure Oracle WebUtil Package with Oracle forms 10g in simple steps.
(Click to download complete webutil documentation)

Configuring WebUtil:

1. Click to download package: Link 1 or Direct Link 2
2. Extract both rar to some directory.
3. 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


4. In $ORACLE_HOME/forms/server/formsweb.cfg file
Change the following entries

# 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 

5. 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

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

For Example :

{

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

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

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

}

This will start a process and end with a message 1 file copied successfully 

Configuring Database:

1. Connect as Scott or your User 
2. Run the script $ORACLE_HOME/forms/create_webutil_db.sql using SQLPLUS or any tool.

Setting up Form Builder:

1. Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
2. File > Save as and Rename the file to different name e.g WebUtil_lib
(Trust me it works to avoid Webutil not found error) :)
3. Compile the new PLL file and generate it
4. Attached the new named Webutil_lib.pll to your form with Remove Path option YES.
5. Open WebUtil.olb file Object group in builder and copy or subclass it into your form.
6. Now compile your form and run it.

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.
7. Press Browse button on form and choose Datafile.txt and Press Open...Text file will load into the Data Block.

For more clarification watch below video:

Please feel free to comment on this and inform me if I missed something.

WUC-19: Unable to write to local file in Windows

Problem:

I  can not download the jacob.dll, JNIsharedstubs.dll and D2Kwut60.dll

I’m able to download and save the file on client directly by putting the download in browser, but through application, it gives below errors.

WUC-19: Unable to write to local file
c:\Progra~1\Oracle\Jiniti~1.22\bin\JNIsharedstubs.dll.Failed to download URL
https://xxxxx.xxx.edu.my/forms/webutil/d2kwut60.dll
WUC-19: Unable to write to local file
c:\Progra~1\Oracle\Jiniti~1.22\bin\d2kwut60.dll.
Failed to download URL
https://xxxxx.xxx.edu.my/forms/webutil/d2kwut60.dll

Solution:

Step 1: Drag UAC (User Account Control) vertical slider to minimum

Step 2: Restart the PC

Step 3: Login into your company web database. You will see all the necessary files from the web server will be copied to your local hard disk.

Step 4: You may reset the UAC settings back to the default level. The above files are copied to your local hard disk only once.

ANOTHER SOLUTION: 

Depending on user permissions, you might receive possible errors when accessing a Forms application using Webutil such as:
“WUC-19: Unable to write to local file C:\Program Files (x86\Java\jre6\bin\jacob.dll”
If that is the case, it is recommended to dedicate a directory to where users would have the right to download to. After creating the directory, you will need to do the following:

1. Copy d2kwut60.dll, jacob.dll, and JNIsharedstubs.dll into the directory
2. On the server where you are accessing the Forms application from, open webutil.cfg in a text editor
3. Copy the line “#install.syslib.location.client.1=webutil/syslib” and paste it below. HINT: This line is in the middle of the document.
4. Uncomment the line you pasted
5. Replace webutil/syslib with the full path to the directory where the 3 dlls will be located in.
6. Save all changes in webutil.cfg

After that, you should be able to log into your Forms application without a problem.

WUC-24: Error Reading URL

Solution:

Copy Webutil folder which contains all 3 .dll files and paste it into java folder

<Oracle_Home>/Forms/Webutil 

to 

<Oracle_Home>/Forms/Java/Webutil