-
WebUtil and Oracle AS 10.1.2 PatchSet 2 Problem
-
During the last weeks I faced with two customers some problems concerning WebUtil and Oracle AS 10.1.2.2.0, e.g. a Reports Call over WebUtil was not working or the WebUtil function file_open_dialog was not working a.s.o. Under Oracle AS 10.1.2.0.2 everything was working fine.
The problem came out of the PatchSet 2 (Patch-No. 4960210) which didn't apply the frmwebutil.jar to the Oracle AS you wanted to patch. To solve this problem just follow these steps:
- unzip the PatchSet 2 to any directory which you prefer
- go to the directory /Disk1/stage/Patches/oracle.developer.forms.builder/10.1.2.2.0/1/DataFiles/ in your unzipped PatchSet 2
- Place the jar utility of the Oracle AS into your $PATH with following command: export PATH=$ORACLE_HOME/jdk/bin:$PATH
- Extract the needed frmwebutil.jar from the Java archive webutil.2.2.jar with following command: jar xf webutil.2.2.jar frmwebutil.jar0
Attention: the filename to extract is frmwebutil.jar0 (=Zero)
- Make a backup copy of the actual frmwebutil.jar in your $ORACLE_HOME with following comand: mv $ORACLE_HOME/forms/java/frmwebutil.jar $ORACLE_HOME/forms/java/frmwebutil.jar.save
- Copy the extracted frmwebutil.jar0 to your $ORACLE_HOME with following command: cp frmwebutil.jar0 $ORACLE_HOME/forms/java/frmwebutil.jar
After these steps just restart your Oracle AS or at least restart the OC4J Instance OC4J_BI_Forms and test your Forms Application with your WebUtil functions.
-
Network Traffic in Oracle Forms
-
Regularly I get the questions from my customers "What is the network traffic in my Forms applications?". A simple way to display the number of transmitted bytes and number of round trips is to add the parameter networkStats=true in your Named Configuration inside your formsweb.cfg configuration file. Additionally you have to modify the corresponding base*.htm or webutil*.htm as follows:
<PARAM NAME="networkStats" VALUE="%networkStats%">
Inside the Tag <EMBED...> add following:
networkStats="%networkStats%"
After the modifications startup your Forms application and in the status bar of your application you'll find on the button right side a counter n:m. Where n = number of transmitted bytes and m = number of round trips.