Oracle® Application Express Patch Set Notes
Release 4.1.1.00.23
 
 

 

Oracle® Application Express

Patch Set Notes

Release 4.1.1.00.23

 

February 2012

These patch set notes accompany the Oracle Application Express 4.1.1.00.23 patch set. The Oracle Application Express 4.1.1.00.23 patch set is a cumulative patch.

This document contains these topics:

1 Patch Set Overview

Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they typically do not include new functionality and they do not require certification on the target system.

Patch sets include all of the libraries that have been rebuilt to implement the bug fixes in the set. All of the fixes in the patch set have been tested and are certified to work with each other.

Patch sets contain the same set of generic fixes across all platforms. Patch sets may also include additional patches specific to the platform on which they are released.

The Oracle Application Express 4.1.1.00.23 patch set can be applied to Oracle Application Express release 4.1. Apply the patch to the Oracle database where the Oracle Application Express schemas are installed. This patch will determine if additional languages are installed, and will apply the patch for those languages as well. Oracle Application Express release 4.1 is supported on Oracle Database 10g (10.2.0.4) and higher.

When determining whether or not to install this patch set, consider the following rules:

  1. If you have Oracle Application Express release 4.1 installed, download the Oracle Application Express 4.1.1 patch set and apply it. To obtain the patch go to My Oracle Support and search for patch number 13331096.

  2. If you have Oracle Application Express release 4.0 or earlier installed (including Oracle HTML DB release 1.5), download and install the entire Oracle Application Express 4.1.1 release from the Oracle Technology Network (OTN).

  3. If you do not have Oracle Application Express installed, download and install the entire Oracle Application Express 4.1.1 release from the Oracle Technology Network (OTN).

2 Pre-Installation Tasks

Complete the following pre-installation tasks before installing the patch set.

Topics:

2.1 Identifying the Oracle Application Express Installation

This is not a complete software distribution. You must connect to an existing Oracle Database where the Oracle Application Express schemas are installed and run the apxpatch.sql installation script.

2.2 Downloading and Extracting the Installation Software

Download the patch set to a computer with access to the Oracle Database. You will also need access to the Oracle home.

To download and extract the patch set installation software:

  1. Download the p13331096_11202_GENERIC.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

  2. Unzip and extract the installation files as follows:

    • Microsoft Windows - Double-click the p13331096_11202_GENERIC.zip file

    • UNIX or Linux - Enter the following command:

      $ unzip p13331096_11202_GENERIC.zip
      

2.3 Optionally Backing Up the Oracle Database

The Application Express engine is a collection of tables and packages that reside wholly within the Oracle Database user accounts APEX_040100 and FLOWS_FILES. This patch set updates the underlying tables and packages within the APEX_040100 account. If your installation fails, you will not be able to rollback the patch set installation process. Therefore, Oracle recommends that you perform a complete backup of your Oracle instance before you install the patch set. Note that after the patch set is installed there is no way to remove it.

If you choose to perform a backup, restart the Oracle Database in restricted session mode to prevent any user access (that is, developer and end-user) while applying the patch set.


See Also:

Oracle Database Backup and Recovery User's Guide at:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm

 

2.4 Preventing Access to Oracle Application Express

It is important that no developers or end users access Oracle Application Express while you are applying the patch set. This section describes how to start Oracle Application Express if your configuration includes Oracle HTTP Server and mod_plsql, embedded PL/SQL gateway, or Oracle Application Express Listener.

Topics:

2.4.1 Stopping Oracle HTTP Server

If your configuration includes Oracle HTTP Server and mod_plsql, you need to stop Oracle HTTP Server. To stop Oracle HTTP Server shipped with Oracle Database 10g release 1 (10.1) or later, enter commands using the following syntax, where ORACLE_BASE is the path to the Oracle base directory:

ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server

Note that if the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).

2.4.2 Disabling Oracle XML DB HTTP Server

If your configuration includes the embedded PL/SQL gateway, you need to disable the Oracle XML DB HTTP Server. The embedded PL/SQL gateway runs in the Oracle XML DB HTTP server in the Oracle database. To disable it, you change the port number to 0. Before doing so, verify the port number. See "Verifying the Oracle XML DB HTTP Server Port".

To disable Oracle XML DB HTTP server:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

    • Windows:

      DRIVE_LETTER:\> sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
    • UNIX and Linux:

      $ sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
  2. Run the following statements:

    EXEC DBMS_XDB.SETHTTPPORT(0);
    COMMIT;
    
2.4.2.1 Verifying the Oracle XML DB HTTP Server Port

To verify the port number where the Oracle XML DB HTTP Server is running:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  2. Enter the following statement to verify the port number:

    SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
    

    If the port number returns 0, the Oracle XML DB HTTP Server is disabled.

2.4.3 Stopping Oracle Application Express Listener

To learn more about stopping the Oracle Application Express Listener server, see Oracle Application Express Listener Installation and Developer Guide:

http://docs.oracle.com/cd/E21611_01/doc.11/e21058/toc.htm

3 Installation Tasks

Complete the following tasks to install the patch set:

  1. Set your current directory to the top-level "patch" directory where you unzipped the p13331096_11202_GENERIC.zip file.

  2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  3. Run apxpatch.sql. For example:

    @apxpatch.sql
    
  4. Review the log file apxpatch.log for any errors.

4 Post-Installation Tasks

Complete the following post-installation tasks before using the upgraded software.

Topics:

4.1 Updating the Images Directory

During an upgrade, you must incorporate the new images directory. Copy the patch/images directory into the images directory used for Oracle Application Express.

Topics:

4.1.1 Updating the Images Directory When Running Oracle HTTP Server

To locate the images directory on the file system, review the following files for the text alias /i/:

  • Oracle Application Server 10g - See the marvel.conf or dads.conf files.

  • Oracle HTTP Server distributed with Oracle Database 11g - See the marvel.conf or dads.conf files.

When you locate the images directory path, copy it to the existing ORACLE_HTTPSERVER_HOME home.

On a Windows system, run a command from a command prompt similar to the following example:

xcopy /E /I patch\images ORACLE_HTTPSERVER_HOME\Apache\Apache\images

On UNIX or Linux based systems, run a command similar to the following example:

cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache

In the preceding syntax examples, ORACLE_HTTPSERVER_HOME is the existing Oracle Application Server or Oracle HTTP Server Oracle home. The location of the Oracle Application Express images directory may be different in your configuration.

4.1.2 Updating the Images Directory When Running the Embedded PL/SQL Gateway

The images in an Oracle XML DB HTTP Server with the embedded PL/SQL gateway installation are in the XML DB repository. Updating the images is accomplished by running the SQL Script apxldimg.sql located in the top level directory where the patch was unzipped.

To update the images directory:

  1. Set your current directory to the top-level "patch" directory where you unzipped the p13331096_11202_GENERIC.zip file.

  2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  3. Run apxldimg.sql passing the file system path to the "patch" directory where the p13331096_11202_GENERIC.zip file was unzipped as shown in the following example:

    • On Windows:

      @apxldimg.sql SYSTEM_DRIVE:\TEMP\patch
      
    • On UNIX and Linux:

      @apxldimg.sql /tmp/patch
      

4.1.3 Updating the Images Directory When Using Oracle Application Express Listener

If you are using the Oracle Application Express Listener, you need to recursively copy the patch/images directory to the Oracle Application Express images directory setup for the Oracle Application Express Listener. For more information, see "Upgrading Oracle Application Express Images" in Oracle Application Express Listener Installation and Developer Guide:

http://docs.oracle.com/cd/E21611_01/doc.11/e21058/install.htm#CHDDEECC

4.2 Starting Oracle Application Express

This section describes how to start Oracle Application Express if your configuration includes Oracle HTTP Server and mod_plsql, embedded PL/SQL gateway, or Oracle Application Express Listener.

Topics:

4.2.1 Starting Oracle HTTP Server

To start Oracle HTTP Server shipped with Oracle Database 10g release 1 (10.1) or later, enter commands using the following syntax, where ORACLE_BASE is the path to the Oracle base directory:

ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server

Note that if the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).

4.2.2 Enabling Oracle XML DB HTTP Server

Once disabled, you enable embedded PL/SQL gateway by assigning a port number.

To enable Oracle XML DB HTTP server:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

    • Windows:

      DRIVE_LETTER:\> sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
    • UNIX and Linux:

      $ sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
  2. Run the following statements:

    EXEC DBMS_XDB.SETHTTPPORT(port);
    COMMIT;
    

    For example:

    EXEC DBMS_XDB.SETHTTPPORT(8080);
    COMMIT;
    

Note:

Port numbers less than 1024 are reserved for use by privileged processes on many operating systems. To enable the XML DB HTTP listener on a port less than 1024, such as 80, review the following documentation:
  • "Using Protocols to Access the Repository" and "Using HTTP(S) on Nonstandard Ports" in Oracle XML DB Developer's Guide.

  • "Protocol Address Configuration" and "Port Number Limitations" in Oracle Database Net Services Reference.


 

4.2.3 Starting Oracle Application Express Listener

To learn more about starting the Oracle Application Express Listener server, see Oracle Application Express Listener Installation and Developer Guide:

http://docs.oracle.com/cd/E21611_01/doc.11/e21058/toc.htm

4.3 About Patching Oracle Application Express After Translating Languages

It is safe to apply the Oracle Application Express 4.1.1.00.23 patch set repeatedly to an Application Express 4.1 instance. If you load additional translated versions of Oracle Application Express after applying this patch, you should apply the entire patch set again.

5 Known Issues

This section describes bugs and known issues for Oracle Application Express.


Tip:

This section is current as of the writing of this document. To view the most current listing of known issues, go to the Known Issues page available off the Downloads page. See:
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

 

This section contains the following topics:

5.1 Page Protection Violation After Patch Set Installation

After a patch set installation, users get the following error when they try to log in or submit a page:

Page protection violation: This may be caused by manual alteration of protected
page items. If you are unsure what caused this error, please contact the
application administrator for assistance

Solution:

Restart Oracle Application Express Listener. For more information, see Oracle Application Express Listener Installation and Developer Guide:

http://docs.oracle.com/cd/E21611_01/doc.11/e21058/toc.htm

6 Fixed Bugs

The Oracle Application Express 4.1.1.00.23 patch set is a cumulative patch. This patch set includes release 4.1 and additional product fixes. The following table lists bugs fixed in the Oracle Application Express 4.1.1.00.23 patch set.

Table 1 Bugs Fixed in the Oracle Application Express 4.1.1.00.23 Patch Set

Bug Number Description

11795230

ORA-20503/checksum error when editing a calendar in Microsoft Internet Explorer in Spanish and French

12760234

Interactive report JavaScript file included on a page is not minified version

12810162

Theme 23 - Disabled items do not show as disabled

12832290

SQL statement is always running and no result returns when uncheck Autocommit

12850780

Dynamic action constraint error when importing application

12859776

Open Door/built-in login page does not allow setting of items in post authentication

12864463

Theme interactive report region default not set during Create Form and Report Wizard

12897545

Improve performance of code in debug messages

12901398

Tabular form - Export to CSV inserts an empty line

12920353

Help page cannot find in BLOB format mask page

12926266

Regexp_Instr not a valid interactive report filter expression

12927199

Export translations results in error ORA-06502 when translating large values

12927540

Imported translations have an incorrect mapping from ID

12934733

Not able to update Web service process

12934779

Exists/Not Exists/PLSQL expression does not work for hierarchical list entry

12940001

ORA-6502 error raised if list entry label is longer than 255 characters

12940032

Copy List wizard for list in another application throws error when user clicks Next button

12941780

Events Onchange do not work with popup key LOV in tabular form

12948371

JavaScript error raised when editing page template

12951754

Tabular Form using ROWID and allowed operations, update and insert fails

12955671

HTTP Header variable authorization: Endless redirect if username is case sensitive

12965697

Columns retain previous results when create two calendar pages continuously

12965749

ORA-06502 error occurs when Create a Calendar Page contains multibyte column name

12971989

Button with redirect to page double escape item values in URL

12985053

Interactive reports: Text color of highlighted legend is not shown

12990445

Insert on updatable view does not work (as expected)

12991736

Install application with supporting objects sometimes throws error

12991953

Oracle Application Express 4.1: Oracle Application Express is shown as invalid after converting from full to runtime only

13010348

ORA-6502 error on Manage Instance, Instance Settings, after upgrade to Oracle Application Express 4.1

13014776

ORA-6502 error not cleared from exception stack if "Is Numeric" validation fails

13014831

(Table) Not Found error displays with a valid BLOB download format mask

13018546

Do not allow change position of row selector column with drag and drop

13019188

Cannot change list type on Edit Region page for list regions

13019188

Cannot change list type on Edit Region page for list regions

13021643

Data Grid Query: Add Row button is at the same position of Search button

13025191

$s and $v do not work for Password item types

13029560

Interactive report AJAX calls generating two Activity Log entries

13035437

Publish template branches to page 0

13038430

Performance issue with Flash charts after migration from SVG charts

13039228

Quick Pick (Icon 4) on 4000:601, Interactive Report attributes - Link Column not working

13045147

APEX_CUSTOM_AUTH.POST_LOGIN should not call authentication function

13045478

APEX_UTIL.PREPARE_URL does not use session zero if alias names are lowercase

13050595

Create public API to set build options

13076709

Reports region based on PL/SQL block raises error if code contains tab at end

13078842

ORA-01481 error when using Data Loading against with PLSQL_OPTIMIZE_LEVEL = 3

13092137

Session Sentry function executed for login page causes login issues

13092291

After Migration to release 4.1: Authentication does not work for translated applications

13097973

Session time zone changes when p_lang specified

13249070

Branch after creating manual Web reference should branch to Launch wizards

13251131

Incorrect remove and add of attributes in column groups

13253270

Theme 23, template for the Calendar template contains repeated Height attribute

13261711

Dynamic action - set value for multiple items sometimes loses defined item order

13261856

Database Configuration Assistant (DBCA) results in Oracle Application Express error

13262578

Websheets Edit page gives JavaScript error

13263156

Two unnecessary themes are loaded into the repository upon new installation

13344303

Interactive report column filter should reset pagination

13349581

Hierarchical breadcrumbs are not shown

13349668

Bookmarked links do not work on Websheets, always get the Home page

13355663

Workspace export no longer works

13359643

Custom authentication: error if PL/SQL code contains :App_User and user changes

13364970

Session time zone does not support time zone regions or DST

13375538

Oracle Application Express export -Export feedback not working in 4.1

13385818

Error highlighting does not work when upgrading from Oracle Application Express release 4.0 to 4.1

13386166

Oracle Application Express fails to prompt for change of password

13386636

Oracle Application Express 4.1 incorrectly generates JsTree data for tree

13399250

Data loading: Unable to identify new lines, reading the file as one line

13405604

Validation required when the customer is not selected for placing an order

13412658

Error occurs when saving timestamp data which is displayed as text

13424204

ORA-20001: error creating application translation map when importing 4.0 applications

13438960

Microsoft Internet Explorer 7 Only - Data grid query: Add Row button is at the same position of search

13441441

Dynamic action affected region ID, not properly cleared when it should be

13446313

Missing/wrong page item reference replacement in copy page

13470364

Region source not visible if region plug-in uses "Region Source Is Plain Text"

13476059

Region selector shows regions which are hidden by the Customize feature

13481763

Shared component files do not include a file type

13486526

ORA-20987 error after SSO re-login with Microsoft Internet Explorer 8 and Oracle Application Express 4.1

13490773

Unable to display users in icon view in 4350:55

13495616

Save button is missing in Query Builder page (4500:1002)

13496153

Candlestick chart decimal places value not reflected in tooltip information

13496513

Interactive report date column filter with To_Timestamp degrades performance

13502324

Data Loading: Lookup display columns are not correctly displayed

13503784

Getting ORA-1481 error when uploading six digit numbers

13506223

Current list entry option Page_Range not supported

13510548

Error_Backtrace not correct in error handling record

13515461

Build status of imported database applications hardcoded

13515612

Not able to log in to Application Builder with a different language

13517031

Export of supporting objects defaults to No

13519460

Copy Page fails when dynamic action references an item button

13524077

Clicking interactive report Actions menu goes to top of page if use ALT Actions menu

13524990

ORA-20876: Stop APEX Engine error should be ignored in On Demand process

13530180

Report on page 4000:173 double escapes template name

13532731

After upgrade from Oracle Application Express release 3.2.1 to 4.1, reports output to CSV contains HTML tags

13532973

Data Loading: Special characters and numbers at the beginning of column names not supported

13548011

Row filter aliased with // in output of interactive report

13561697

APEX_ITEM popup APIs not working properly when used in interactive reports

13563808

DML forms that use ROWID do not allow branch to the same form page after update

13570896

Unable to create Text section in Websheet application

13577507

Browser_Cache in view APEX_APPLICATION_PAGES returns wrong value

13578329

Interactive report group by displays incorrect sum if row exceeds pagination

13582661

Data Loading: Failed to retrieve values (lookup) when null value is uploaded

13583014

Drill down/drill up links do not work in Object Browser on Data tab

13584762

Row highlighting does not work in classic report in Oracle Application Express 4.1

13587192

Quick picks are displayed for read-only page items and in Printer Friendly mode

13595606

ORA-00933 error occurs on Instance Settings page (4050:131) in Internal Administration

13600804

Unable to save some hexadecimal values in tabular form

13614028

Application search raises ORA-20555, ORA-00904: "Table_Id": Invalid Identifier

13619617

Websheet data grid adds data to wrong data grid if use browser Back button

13623470

Conversion of Wizard report to Classic results in incorrect column name settings

13628054

Rendering of dynamic lists could have performance impact on high concurrent systems

13634082

Page item of type File Browse does not work on page 0

13635954

Create data upload error: Ora-01403: No Data Found

13639186

Cannot drop constraints while use the Drop button in Object Browser

13640940

Excessive copies of LOV queries in shared pool from Oracle Application Express

13643580

Team Development Settings: Throws error when click Apply Changes with default settings

13645695

Microsoft Internet Explorer 7: Layout of packaged applications on 4000:50 incorrect

13656397

Data upload unique key: Data/timestamp format detection issue

13681987

Feedback Is enabled for application 4000

13682279

APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION should support MUST_NOT_BE_PUBLIC_USER

13682500

List template substitution string #Parent_Text# not replaced

13689232

Ora-00911: invalid character error when attempting to compile view in Object Browser

13692034

Microsoft Internet Explorer 8 raises JavaScript error for refreshing charts


 

7 Other Issues and Changes

This section describes other changes included in Oracle Application Express that are not documented elsewhere.

This section contains the following topics:

7.1 Addition of Theme 24

This patch set includes a new theme, Theme 24. Theme 24 incorporates HTML5 and CSS3 features and is based on the colors used in Oracle Public Cloud.

7.2 Changes in Page and Region Caching

Because of bug 13722696, this release includes the following changed behavior for page and region caching:

  1. If a cached region or a cached page contains protected page items of the following types, it will never be cached independent of the specified cache settings:

    • Hidden where Value Protected is set to Yes.

    • Display Only where Save Session State is set to Yes.

    • Text Field where Disabled is set to Yes and Save Session State is set to Yes.

    • Page Items where the read only condition evaluates to true.

  2. If the URL which is used to render a page contains application or page items which are set in session state (for example, f?p=631:7:609442841545301::::P7_CUSTOMER_ID:7 ) then the existing regions or page caches will not be used and no new caches are stored independent of the specified cache settings.

  3. If the application is running in debug mode, caches are now used. Previously, Debug mode always disabled caching.

7.3 Columns Used in Automatic Row Processing (DML) Processes

Because of bug 12990445, the following changes have been implemented for Automatic Row Processing (DML) process types. The code which performs the INSERT has been changed to determine if the columns should be included in the INSERT statement. Note that these are the same checks which occur before an UPDATE. These new checks include:

  • Is the source type a DB Column?

  • Does the specified Build Option have a status of Include or is it not specified at all?

  • Is the page item contained in the POST request? For example, if the page item is conditional it will not be contained in the POST request if the condition evaluates to FALSE during page rendering.

  • Is the page item not of type Display Only where Save State is set to No?

The above new behavior is used for all new applications which are created in Oracle Application Express release 4.1.1.

For existing applications where the compatibility mode is set to 4.0, the old behavior of including all page items will still be used to prevent breaking existing applications.

To change an old application to use compatibility mode 4.1, run the following statement in SQL Workshop, SQL Commands:

begin 
apex_util.set_compatibility_mode(<application id>, '4.1); 
commit; 
end; 

To learn more, see "SET_COMPATIBILITY_MODE Procedure" in the Oracle Application Express API Reference:

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_util.htm#CHDJDIEA

See Also:

Oracle Application Express Release Notes for release 4.1 to learn more about the impact of changing the compatibility mode from 4.0 to 4.1:
http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21672/toc.htm


 

8 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

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.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.


Oracle Application Express Patch Set Notes, Release 4.1.1.00.23

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.