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