This preface contains:
The following are changes in Oracle Application Express Installation Guide for Oracle Application Express release 4.2 for Oracle Database 12c.
The following features are new in this release:
Oracle Database 12c introduces 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.