The resulting application, with the menu and the date picker visible, looks like this:
|1.|| Have access to or have installed Oracle Forms version 11.1.1. You may use either Release 1 (R1) or Patch Set 1 (PS1), although the directory structures of these releases are somewhat different. |
|2.||Have access to an Oracle database with the scott schema ( EMP and DEPT ) installed. |
Warning: For security reasons, it may not be advisable to install the sample schemas into a production database. If you do install them, you should use passwords other than default passwords, although default passwords are used in the examples shown in tutorials provided by Oracle. When you are finished using the sample schemas for tutorial and demo purposes, you may drop them by issuing the following SQL*Plus command for each installed sample schema:
If you are using the sample schemas for the first time, you may find that you must unlock the schema user, and then grant CONNECT and RESOURCE roles to it. You can do this by using Oracle Enterprise Manager, which is part of Oracle.
Alternatively, you can issue the following SQL*Plus commands:
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to scott;
- CSS: CSS stands for Cascading Style Sheets, which you can use to define the style of a Web site. You use it in the demonstration application to make the applet appear to be a part of the larger browser page.
|1.||From the expanded zip file, copy the .fmb files ( found in the JSInteg\Solutions\jsdemo |
|2 .|| Open the modules in Forms Builder, connect as scott, and compile the forms to the same directory as the .fmb files. |
|3.|| Copy the js.html file to the Forms configuration directory. The path for this directory is defferent depending on the release of JDeveloper that you are using: |
|4.|| Copy these directories: img, JSCal2, lightbox05, menu , and transEffects |
and these files: jquery.js, jsdemo.css, jsdemo.html, and jsdemo.js
to the following directory:
|5.||Edit jsdemo.html and modify the hostname and port values according to your installation. These values are located toward the end of the file. |
Use the following settings:
|7 .||Edit the default.env file: Add the directory where you saved the forms to the environment variable FORMS_PATH. |
For example, append to FORMS_PATH:
|1.|| Run the application by issuing the following URL in your browser, substituting the value for |
For example, invoke the Query menu, enter an employee name, such as WARD, in the search box, and click Go.
The form displays the record for the specified employee.
|3.|| To redisplay all the records, select Query > Execute from the menu. |
Navigate to the hiredate field in Employees form. Use the up- and down- arrow keys to scroll between records, noticing the corresponding change in the date picker calendar.
|4.|| Select a date from the calendar, which updates the hiredate of the employee record. |
|5 .|| Select View > Departments to navigate to the Department form. |
|6 .|| Scroll up and down to navigate between different departments, noticing the changes in various images. |