1 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. -
REMOVE_WEB_ENTRY_POINT Procedure
- New procedure removes a public procedure from the white list of objects that can be called via the URL. - 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
- The following data types are new to this release:
-
APEX_REST_SOURCE_SYNC
(New) - enables you to synchonize data between tables by merging rows instantly or at scheduled intervals.
-
API_STRING_UTIL
(New)-
GET_FILE_EXTENSION
Function -
GET_SLUG
Function -
DIFF
Function -
PHRASE_EXISTS
Function (formerlyFIND_PHRASE
)
See APEX_STRING_UTIL.
-
-
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 - seeEXECUTE_WEB_SOURCE Procedure (Deprecated)
. -
OPEN_WEB_SOURCE_DML_CONTEXT
Function - seeOPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated)
. -
OPEN_WEB_SOURCE_QUERY
Function - seeOPEN_WEB_SOURCE_QUERY Function (Deprecated)
. -
PURGE_WEB_SOURCE_CACHE
Procedure - seePURGE_WEB_SOURCE_CACHE Procedure (Deprecated)
.
-
- The following
APEX_EXEC
parameter is deprecated:p_module_static_id
- usep_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.