This guide explains how to install and configure Oracle Application Express.
This Preface contains these topics:
Oracle Application Express Installation Guide is intended for anyone responsible for installing Oracle Application Express.
To use this manual, you must have administrative privileges on the computer where you installed your Oracle database and familiarity with object-relational database management concepts.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
Oracle customers have access to electronic support through My Oracle Support. For information, visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
For more information, see these Oracle resources:
Oracle9i Application Server Administrator's Guide
For information about Oracle error messages, see Oracle Database Error Messages. Oracle error message documentation is available only in HTML. If you have access to the Oracle Database Documentation Library, you can browse the error messages by range. Once you find the specific range, use your browser's "find in page" feature to locate the specific message. When connected to the Internet, you can search for a specific error message using the error message search feature of the Oracle online documentation.
Many books in the documentation set use the sample schemas of the seed database, which is installed by default when you install Oracle. Refer to Oracle Database Sample Schemas for information on how these schemas were created and how you can use them yourself.
For additional application examples, please visit the Oracle by Examples (OBEs) Application Express page, located on Oracle's Technology Network. The OBEs provide step-by-step examples with screenshots on how to perform various tasks within Application Express.
Printed documentation is available for sale in the Oracle Store at
To download free release notes, installation documentation, white papers, or other collateral, please visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at
If you already have a user name and password for OTN, then you can go directly to the documentation section of the OTN Web site at
The following text conventions are used in this document:
|boldface||Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.|
|italic||Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.|
||Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.|
Oracle Application Express contains third-party code. Oracle is required to provide the following notices. Note, however, that the Oracle program license that accompanied this product determines your right to use the Oracle program, including the third-party software, and the terms contained in the following notices do not change those rights.
Flash chart support in Oracle Application Express is based on the Anychart Flash Chart Component. Anychart is a flexible Macromedia Flash-based solution that enables developers to create animated, compact, interactive flash charts. Flash charts are rendered by a browser and require Flash player 8 or later. Flash charts used in interactive reports require Flash Player 9 or later. For more information about Anychart, go to
Any attempt to unbundle the AnyChart Flash Chart Component from an Oracle product, or to use the AnyChart Flash Chart Component outside of the Oracle product will be in violation of this license and will result in the immediate termination of this license.
This release of Oracle Application Express includes the AnyChart AnyGantt Flash Gantt Component and the AnyChart AnyMap extension. These products are not exposed through the Oracle Application Express user interface, but can be used programatically in any Oracle Application Express application. To learn more, see:
AnyChart AnyGantt Flash Gantt Component:
AnyChart AnyMap extension:
Any attempt to unbundle the AnyChart AnyGantt Flash Gantt Component or the AnyChart AnyMap extension from an Oracle product, or to use the AnyChart AnyGantt Flash Gantt Component or the AnyChart AnyMap extension outside of the Oracle product will be in violation of this license and will result in the immediate termination of this license.
Oracle Application Express uses FCKeditor version 2.3.2 for the following item types; HTML Editor Minimal and HTML Editor Standard. This software is licensed under the Apache License, Version 2.0 (the "License"). To view a copy of the Apache License, see Appendix C, "Third-Party License".
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
For more information about FCKeditor, go to:
Oracle Application Express includes the Apache FOP Version 0.20.5 libraries and a custom XSL-FO processing JSP. This software is licensed under the Apache License, Version 2.0 (the "License"). To view a copy of the Apache License, see Appendix C, "Third-Party License".
If you wish to use Apache FOP as your report server for PDF region printing, this is now a supported report server configuration. Installation and configuration instructions can be found on Oracle Technology Network. See Installing and Configuring Apache FOP at: