Changes in This Release

This preface contains:

Changes in Oracle Application Express Release 4.2 for Oracle Database 12c

The following are changes in Oracle Application Express Installation Guide for Oracle Application Express release 4.2 for Oracle Database 12c.

New Features

The following features are new in this release:

  • Oracle Database 12c introduces the multitenant architecture

    See "Utilizing the Multitenant Architecture".

  • Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types

    The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32K characters. Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.

    In order for Application Express collections to be able to utilize the increased size limit you must run /core/collection_member_resize.sql to change collection VARCHAR2 columns from 4000 characters to 32767 characters.

  • RESTful Web Services

    In SQL Workshop you can now define RESTful Web Service calls from the database. These definitions combined with Oracle REST Data Services 2.0 enables the database to emit RESTful Web Services rather than just being able to consume Web Services. See "Using RESTful Services" in Oracle Application Express SQL Workshop and Utilities Guide

    RESTful Services require the installation of Oracle REST Data Services release 2.0. See "Configure RESTful Services".

    The instance administrator enables RESTful Services for this Application Express instance. See "Configuring SQL Workshop" in Oracle Application Express Administration Guide.

Other Changes

The following are additional changes in the release:

  • All content has been updated to reflect new functionality.

  • Screen captures and graphics have been added and updated to reflect Oracle Application Express release 4.2 user interface enhancements.