السلام عليكم اخواني الاعزاء
احببت أن اشارك معكم بهذا الموضوع المهم ولكن لاحظت ان الموضوع فيه بعض الصعوبات وخاصة عند القيام بالتنفيذ النهائي على الفورم وليس عملية التجهيز الاولية والتي في بداية الشرح لذلك

ارجو من اخواني اصحاب الخبرة ان يقوموا بشرح هذا الموضوع بنفس هذه الخطوات المبسطة والواضحة في اغلبها
ولكم جزيل الشكر

Today i m going to show the How to configure Oracle WebUtil Package with Oracle forms 10g in simple steps with working example that i have created.

In this example we'll upload a Text file (Fields separated by Comma ) into Oracle Forms data block.
Download Text file and FMB
Before we start we have to configure WebUtil to work with Forms here are the steps

Updated July 14, 2010 A good Forms 10g Configuration manual by my collegue Mr.Moiz can be found here



Configuring WebUtil at OS:

1.Download WebUtil http://www.oracle.co...webutil_106.zip
2. Download Java Com Library http://prdownloads.s...ct/jacob_18.zip
3. Extract both zips to some directory.
4. 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


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

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

7. Add frmwebutil.jar and Jacob.jar path entries into Windows Registry (Start > Run > type regedit and press enter) goto HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE > DEVSUITE_HOME > FORMS_BUILDER_CLASSPATH Variable.
Note: if you are using Linux then instead of this setup the environment variable.

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

C:\DevSuiteHome_1\forms\webutil>sign_webutil.bat c:\DevSuiteHome_1\forms\java\frmwebutil.jar
C:\DevSuiteHome_1\forms\webutil>sign_webutil.bat c:\DevSuiteHome_1\forms\java\jacob.jar



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.

Feel free to comment on this if i missed something plz inform me.

Check this Manual for further info on WebUtil
http://www.oracle.co...il/web_util.pdf

السلام عليكم
اليك شرح وافى عربى و انجلزى Webutil Config Help
بالتوفيق .
ونسالك الدعاء.

يا شباب الموضوع مش ناقص تعقيد
لو ممكن بطل من الابطال يشرح الموضوع دة
او يوضح القصة
وجزاكم الله عنا كل خير

السلام عليكم ....
هل انت قرات الشرح بتاعى الاول ...ايه اللى معقدك يا اخى الشرح فى حاجه مش واضحه (الشرح شغال و ناس كتير اشتغلات عليها من غير مشاكل .).
بنسبه لمشكلاتك اللى انت رافع فيها صوره فى موضع تانى ....
خلى البلوك اللى اسمه WEBUTIL (اللى بينزل من OBJECT_GROUPالخاص بى مكتبه WEBUTIL). اخر بلوك فى الاوبجيت نيفجتور.
هيشتغل معاك.مستنى النتيجه.
بالتوفيق .

تم تعديل 6 نوفمبر 201015 سنة بواسطة mostfa_future

بسم الله الرحمن الرحيم
السلام عليكم ورحمة الله وبركاته
يمكنك مراجعة هذا الرابط
http://www.arabteam2000-forum.com/index.php?showtopic=97213

`https://www.youtube.com/watch?v=7iar6zB7vwM&list=UU0dYTCvZpuYXBWiVrH-ghkA&index=14
Oracle Developer 10g Webutility Configuration
And Morr
Gooo and see