This tutorial covers how to complete, test and deploy the application you built in part 2. You will examine how to manipulate a list on Page 0, add a drop down list to your tabs, add error handling and debug your application, build and deploy a packaged application.
Time to Complete
Approximately 60 minutes
Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.
In this tutorial, you use Oracle APEX Release 4.1.1 to complete and deploy the application you built in Enhancing Your Oracle Application Express Application: Part 2 of this workshop.
Before starting this tutorial, you should:
- Have access to an Oracle Database 11g database that has the sample schema installed.
- Have installed Application Express Release 4.1.1 into your Oracle Database 11g database.
- Create a workspace called HR that is based off the HR schema with the admin username of HR and a password of oracle.
- Perform the Building an Application using Oracle Application Express: Part 2 tutorial or import the f100_result.sql application which contains the application that was created in this tutorial.
- Download and unzip the files.zip into your working directory.
Creating a List
In this topic, you create a list.
Enter the following information and click Next.
|List Entry Label||Target Page ID|
|View Project Schedule||
|Load Project Data||
Creating Page Zero
In this topic, you create Page Zero. Page Zero contains all the regions and processing that you want to perform on every page unless otherwise specified. In this case, you want to add the list you created in the previous section on the right side of each page in your application. Perform the following steps:
Adding the List to Page Zero
In this topic, you add the list you previously created to Page Zero. Perform the following steps:
In this topic, you reorganize and modify the tabs. Perform the following steps:
Change the Labels as indicated below in bold and change the Chart sequence number to 2 so that it is first. Then click Apply Changes.
||View Project Schedule
||Load Project Data
Adding Error Handling to Your Application
In this topic, you add error handling to your application. You create a table that stores all the constraints with the error that should be displayed when it occurs. In addition, you create a function that processes the error. In this example, you create a unique constraint on the department name. Perform the following steps:
Uploading and Executing Necessary Error Handling Scripts
Associating Error Handling Function with Your Page
Testing the Error Handling for your Page
Debugging Your Application
In this topic, you review your application in debug mode. Perform the following steps:
Checking Your Application Using the Advisor
In this topic, you use the Advisor to check your Application for errors and quality checks. Perform the following
Adding and Using Build Options
Build options enable you to conditionally display specific functionality within an application. Build Options have two possible values: INCLUDE and EXCLUDE. If you specify an attribute to be included, then the Application Express engine considers it at run time. However, if you specify an attribute to be excluded, then the Application Express engine treats it as if it did not exist.
In this topic, you add a exclude build option and then associate it with page 7 and 8 and the Load Project Data tab in your application.
Creating a Packaged Application
From a user's perspective, importing and installing an application is a complicated process. First, you create the target database objects and seed data. Second, you import and install the application definition and all related files, including images, themes, and any other required static files.
Creating a packaged application using the Supporting Objects utility greatly simplifies this process. Instead of performing numerous steps to create the database objects and then import and install the application and all supporting files, you can define the supporting objects so that the application and supporting files can be migrated in a few easy steps.
In this topic, you create a packaged application for the Project Tasks Application you have been working on.
In this tutorial, you have learned how to:
- Create a List
- Create Page Zero and add the list to this page
- Modify your tabs
- Add error handling to your application
- debug your application
- check the application using the advisor
- Add and use a build option
- Create a packaged application
To help navigate this Oracle by Example, note the following:
- Hiding Header Buttons:
- Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
- Topic List Button:
- A list of all the topics. Click one of the topics to navigate to that section.
- Expand/Collapse All Topics:
- To show/hide all the detail for all the sections. By default, all topics are collapsed
- Show/Hide All Images:
- To show/hide all the screenshots. By default, all images are displayed.
- To print the content. The content currently displayed or hidden will be printed.
To navigate to a particular section in this tutorial, select the topic from the list.