يا شباب إذا حد ممكن سقدم لنا شرح مفصل مع ضبط الاعدادات ل الويب webutility

السلام عليكم ورحمة الله وبركاته


وش فايدتها هاي

How to config WebUtil 1.06 in Developer Suite 10G on Windows

Assuming a fresh "Complete" install of Oracle Developer Suite 10.1.2.0.2,
here are steps to get a small test form running, using WebUtil 1.06.
Note: [OraHome] is used as an alias for your real oDS ORACLE_HOME.

1) Download http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
and extract to a temporary staging area. Do not attempt to use 1.7 or 1.9.
2) Copy or move jacob.jar and jacob.dll
[JacobStage] is the folder where you extracted Jacob, and will end in ...\jacob_18
cd [JacobStage]
copy jacob.jar [OraHome]\forms\java\.
copy jacob.dll [OraHome]\forms\webutil\.
The Jacob staging area is no longer needed, and may be deleted.
3) Sign frmwebutil.jar and jacob.jar
Open a DOS command prompt.
Add [OraHome]\jdk\bin to the PATH: set PATH=[OraHome]\jdk\bin;%PATH%
Sign the files, and check the output for success:
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\frmwebutil.jar
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\jacob.jar



F:\DevSuiteHome_1\forms\webutil\sign_webutil.bat F:\DevSuiteHome_1\forms\java\frmwebutil.jar
F:\DevSuiteHome_1\forms\webutil\sign_webutil.bat F:\DevSuiteHome_1\forms\java\jacob.jar

Assuming you installed the software on c:\Developer so you'll run the previous Commands Like the following:
C:\Developer\forms\webutil\sign_webutil.bat C:\Developer\forms\java\frmwebutil.jar
C:\Developer\forms\webutil\sign_webutil.bat C:\Developer\forms\java\jacob.jar
4 ) Create a schema to hold the WebUtil stored code, and privileges needed to
connect and create a stored package. Schema name "WEBUTIL" is
recommended for no reason other than consistency over the user base.
Open [OraHome]\forms\create_webutil_db.sql in a text editor, and delete or
comment out the EXIT statement, to be able to see whether the objects were created witout errors.
Start SQL*Plus as SYSTEM, and issue:
CREATE USER webutil IDENTIFIED BY webutil
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
/
GRANT CONNECT, CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO webutil;
/
CONNECT webutil/webutil@orcl
@[OraHome]\forms\create_webutil_db.sql
-- Inspect SQL*Plus output for errors, and then
CREATE PUBLIC SYNONYM webutil_db FOR webutil.webutil_db;
/
Reconnect as SYSTEM, and issue:
grant execute on webutil_db to public;
/
5) Modify [OraHome]\forms\server\default.env, and append [OraHome]\jdk\jre\lib\rt.jar
and [OraHome]\forms\java\jacob.jar to the CLASSPATH entry.
F:\DevSuiteHome_1\jdk\jre\lib\rt.jar
F:\DevSuiteHome_1\forms\java\jacob.jar
Or FORMS_BUILDER_CLASSPATH (at the Registry)... otherwise there is an error
Message when opening the canvas in the new created FMB
6) Ensure JavaScript files are in the correct folder

7) Start the OC4J instance
8) Start Forms Builder and connect to a schema in the RDBMS used in step (4).
Open Webutil.pll, do a "Compile ALL" (shift-Control-K), and generate to PLX
It is important to generate the PLX, to avoid the FRM-40039.
If the PLX is not generated, the Webutil.pll library would have to be attached with
full path information to all forms wishing to use WebUtil. This is NOT recommended.
9) Create a new FMB.
Open webutil.olb, and Subclass (not Copy) the WebUtil object to the form.
There is no need to Subclass the WebutilConfig object.
Attach the Webutil.pll Library, and remove the path.
Add an ON-LOGON trigger with the code
NULL
to avoid having to connect to an RDBMS (optional).
Create a new button on a new canvas, with the code
show_webutil_information (TRUE);
in a WHEN-BUTTON-PRESSED trigger.
Compile the FMB to FMX, after doing a Compile-All (Shift-Control-K).
10) Under Edit->Preferences->Runtime in Forms Builder, click on "Reset to Default" if
the "Application Server URL" is empty.
Then append "?config=webutil" at the end, so you end up with a URL of the form
http://server:port/forms/frmservlet?config=webutil

11) Run your form.


6) Modify Oracle_Home\forms\server\formsweb.cfg insde [default] add :
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
also add :
[webutil]
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
baseHTML=webutilbase.htm
archive_jini=frmall_jinit.jar
WebUtilArchive=frmwebutil.jar,jacob.jar,f90all.jar
archive=frmwebutil.jar,f90all.jar
lookAndFeel=oracle
7) Modify Oracle_Home\forms\server\webutil.cfg and add :
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE


Example 1
1 – From File menu choose (New) then (Form)
2 – in the Object Navigator Click on (attached library) then (+) Button to add
Webutil.pll ( at the folder of Webutil106).





3 – File  open  Choose Webutil.olb


4 - From the object Nevigator  object libraries  right Click  Choose object Library


5 – Drag the (Webutil) icon from the object Library and drop it in the Object Navigator
(on the Module name)

6 – A message will apear  choose subclass

7 – Now you can add a push button to the form and in the (when-button-pressed)
Add the following code :
show_webutil_information (TRUE);
with this button you can see the webutil's version information
8 – Run the Form and press the button to see the result.

مثال 2
1- نفذ جميع الخطوات من حيث إنشاء form جديد و ووضع Webutil .. إلخ .
2- ضع زراً على الفورم و لنسمه upload_picture ، و ضع أيضاً image item على الفورم و سمه Client_picture و إجعل الإثنين داخل Control Block و سمه photo ..
3- في حدث الضغط على الزر upload_picture :
declare
v_file varchar2(250):= CLIENT_GET_FILE_NAME('','','gif Files | *.gif|JPG |*.JPG|' , 'Select a file to upload ' , open_file , True);
image_id ITEM:=FIND_ITEM('photo.client_image');
begin
CLIENT_IMAGE.READ_IMAGE_FILE(v_file , 'GIF', image_id);
end;