Changes in Release 20.2 for Oracle Application Express API Reference

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

New Features and Updates

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

APEX_EXEC (New)
- EXECUTE_REST_SOURCE Procedure - see EXECUTE_REST_SOURCE Procedure.
- OPEN_REST_SOURCE_DML_CONTEXT Function - see OPEN_REST_SOURCE_DML_CONTEXT Function.
- OPEN_REST_SOURCE_QUERY Function - see OPEN_REST_SOURCE_QUERY Function.
- PURGE_REST_SOURCE_CACHE Procedure - see PURGE_REST_SOURCE_CACHE Procedure.
APEX_INSTANCE_ADMIN (Updated)
- ADD_WEB_ENTRY_POINT Procedure - New procedure adds a public procedure to the white list of objects that can be called via the URL.
  
  See ADD_WEB_ENTRY_POINT Procedure.
- REMOVE_WEB_ENTRY_POINT Procedure - New procedure removes a public procedure from the white list of objects that can be called via the URL.
  
  See REMOVE_WEB_ENTRY_POINT Procedure.
- Added the following new parameters:
  - ENABLE_LEGACY_WEB_ENTRY_POINTS
  - RESTRICT_RESPONSE_HEADERS
  - TRACE_HEADER_NAME
APEX_MAIL (Updated)

ADD_ATTACHMENT Procedures - New procedures add BLOB and CLOB attachment types to outbound email messages.

See ADD_ATTACHMENT Procedure Signature 1 and ADD_ATTACHMENT Procedure Signature 2.
APEX_PLUGIN (Updated)
- The following data types are new to this release:
  - t_item_meta_data_result
- The following data types are updated in this release:
  - t_item_render_result
See Data Types Used by APEX_PLUGIN.
APEX_REST_SOURCE_SYNC (New) - enables you to synchonize data between tables by merging rows instantly or at scheduled intervals.

See APEX_REST_SOURCE_SYNC.

API_STRING_UTIL (New and Updated)
- REMOVE_USER Procedure Signature 1
- REMOVE_USER Procedure Signature 2
The previous REMOVE_USER procedure has been divided into two procedures for user ID and user name parameters, respectively. See APEX_UTIL.

Deprecated and Desupported Features

The following APEX_EXEC functions and procedures are deprecated and will be removed in a future release:
- EXECUTE_WEB_SOURCE Procedure - see EXECUTE_WEB_SOURCE Procedure (Deprecated).
- OPEN_WEB_SOURCE_DML_CONTEXT Function - see OPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated).
- OPEN_WEB_SOURCE_QUERY Function - see OPEN_WEB_SOURCE_QUERY Function (Deprecated).
- PURGE_WEB_SOURCE_CACHE Procedure - see PURGE_WEB_SOURCE_CACHE Procedure (Deprecated).
The following APEX_EXEC parameter is deprecated:
- p_module_static_id - use p_static_id instead.

The following APEX_STRING_UTIL functions and procedures are deprecated and will be removed in a future release:
- FIND_FILE_EXTENSION Function
- FIND_PHRASE Function
- TO_SLUG Function
See APEX_STRING_UTIL.

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