Using Oracle Web_Util with Oracle Forms10g

utilzing WEB_UTIL functionality with Oracle Forms10g has never been easier!  Why, because with Oracle Forms10g Rel2, Web_util is already configured.

If you have Oracle Forms installed on your PC, there are   steps that you need to execute in order to bet Web_util Running

1- Download  Jacob.jar and Jacod.dll if you do not already have them (Jacob is a Java Com Bridge). It can be downloaded from http://danadler.com/jacob/

2-copy the two files to   your  forms/java  and  forms/webutil  directory

3- run the create_webutil_db.sql  script  (it can be found in your forms directory).  login to the schema that you are using for you applicaiton.

That is it!

In order to use it, you create your form and you need to attach a directory called webutil.pll  (you man need to compile the library before using it), then you need to open an object library called  webutil.olb and subclass the object group called webuit.  you can do that by copying the webutil from the object library to the object groups node in you form.

To try an example that opens the File Open Dialogue

Add a button and assoicate a when-button-pressed trigger

declare
    dirname varchar2(255);
    v_filename varchar2(255);
begin
    V_FILENAME := CLIENT_GET_FILE_NAME('','','gif Files | *.gif|JPG |*.JPG|' , 'Select a file to Upload ' , open_file , True);
end;

Compile, and save the form, call it module1 and save it at c:\

To run the example, go to the formsweb.cfg file and towards the end locate the [util] and add FORM=c:\module1.fmx

This section of the file should look like the following

webutil]
form=c:\module1.fmx
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=oracle

run the form by  typing the appropriate URL, for example

http://server:port/forms/frmservlet?config=webutil

enjoy