Importing the OEHR Sample Objects

After you download and unzip the OEHR Sample Objects application, import it into Oracle Application Express. During the import process, specify installation of both the application and the supporting objects. Installing the application creates the objects and sample data needed to complete the exercises in this guide.

To import and install the OEHR Sample Objects application:

Log in to Oracle Application Express.

For instructions, see "Logging In to the Hosted Demo Environment" or "Logging In to Your Local Instance".
On the Workspace home page, click Application Builder.

The Application Builder home page appears.
Click the Import button.
For Specify File, specify the following:
1. Import file - Click Browse and navigate to the oehr_sample_objects_installer.sql file.
2. File Type - Select Application, Page, or Component Export.
3. File Character Set - Select the correct character set.
4. Click Next.
Next, you must install the imported file.
To install an imported file, click Next.

The Install Application Wizard appears.
In the Install Application Wizard, specify the following:
1. Parsing Schema - Select the schema you created when you set up your development environment.
2. Build Status - Select Run and Build Application.
3. Install As Application - Select Auto Assign New Application ID.
4. Click Install.
For Install Supporting Objects, select Yes and click Next.
Confirm your selections by clicking Install.
After the installation is completed, click the Home breadcrumb link at the top of the page.

The Application Builder home page appears.

Checking Your Workspace Storage Space

If you experience problems installing the OEHR Sample Objects application, verify the available space in your workspace. If you do not have enough space, request additional storage space.

If you are a workspace administrator, you can:

Determine if you have enough storage space. See "Viewing the Workspace Overview Report" in Oracle Application Express Administration Guide.
Request additional storage space. See "Requesting Additional Storage" in Oracle Application Express Administration Guide.

Deleting the OEHR Sample Objects Application

Deleting the OEHR Sample Objects application and deinstalling the supporting objects completely removes all associated objects and sample data.

To delete the OEHR Sample Objects application:

Log in to Oracle Application Express.
On the Workspace home page, click Application Builder.

The Application Builder home page appears.
Click the OEHR Sample Objects icon.
On the Tasks list, click Delete this Application.

The Deinstall page appears.
To remove all associated objects and sample data, select Remove Application Definition and Deinstall Supporting Objects.
Click Deinstall.

Using HR Schema Instead of OEHR Sample Objects

If you are using a locally installed instance of Oracle Application Express release 2.2.1.1 or later (not a hosted demo environment such as http://apex.oracle.com) and have the HR schema installed, you can perform the exercises in this guide directly against the HR schema.

To do so, you must associate the HR schema with your workspace instead of performing the steps described in "Importing the OEHR Sample Objects".

Note:

The table names in the HR schema do not include the OEHR prefix (EMPLOYEES versus OEHR_EMPLOYEES). Because this guide outlines all the steps using the OEHR schema, you must adjust your selections and code accordingly.

Also, note that other users may be using the HR schema. Therefore, the objects or data within the objects may differ from that shown in this guide.