1 Changes in Release 21.1 for Oracle Application Express API Reference

All content in Oracle Application Express API Reference has been updated to reflect release 21.1 functionality.

New Features and Updates

The following topics have been added or updated for this release:

  • APEX_APP_SETTING (Updates) - new parameter p_raise_error for procedures. See SET_VALUE Procedure.
  • APEX_EXEC (Updates) - new updates to the following contents of the APEX_EXEC package:

    • Global Constants - new filter constants.
    • Data Types - new sdo_geometry_value member under t_value.
    • GET Function - new signature.
    • ADD_FILTER Procedure - new signature.
    • ADD_PARAMETER Procedure - new signature.
    • SET_VALUE Procedure - new signature.

    These changes support the new Map Region which requires SDO_GEOMETRY to be installed in the database to function. See Creating Maps in the Oracle Application Express App Builder User’s Guide

  • APEX_EXPORT (Updates) - new p_type parameter in GET_APPLICATION function. See GET_APPLICATION Function.
  • APEX_JAVASCRIPT (Updates) - new procedure ADD_JET. See ADD_JET Procedure.
  • APEX_JSON (Updates) - new updates to the following contents of the APEX_JSON package:

    • GET_SDO_GEOMETRY Function (new)
    • STRINGIFY Function (new)
    • WRITE Procedure - two new signatures.

    These changes support the new Map Region which requires SDO_GEOMETRY to be installed in the database to function. See Creating Maps in the Oracle Application Express App Builder User’s Guide

  • APEX_UTIL (Updates) - new procedure PRN. See PRN Procedure.

Deprecated and Desupported Features

See Deprecated Features and Desupported Features in Oracle Application Express Release Notes.