الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.

مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

إعداد WebUtil 1.06 with 10.1.2.0.2

Featured Replies

بتاريخ:

للأمانة منقول من MetaLink

Goal
How to get up and running with WebUtil 1.06 included with Oracle Developer Suite 10.1.2.0.2 on a win32 platform 
Solution
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.
Feel free to copy this note to a text editor, and do a global find/replace on 
[OraHome] with your actual value (no trailing slash). Then it is easy to 
copy/paste actual commands to be executed from the note copy.


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

4) If you already have a schema in your RDBMS which contains the WebUtil stored code,
  you may skip this step. Otherwise,
  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 [password]
     DEFAULT TABLESPACE users
     TEMPORARY TABLESPACE temp;
     /
     GRANT CONNECT, CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO webutil;
     /


     CONNECT webutil/[password]@[connectstring]
     @[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 
  to the CLASSPATH entry.

6) Start the OC4J instance

7) 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 (Control-T).
  It is important to generate the PLX, to avoid the FRM-40039 discussed in
  Note 303682.1
  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.

8) 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).

9) 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

10) Run your form.

تم تعديل بواسطة mm_taha

بتاريخ:

thanks

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.