1 Changes in Release 22.2 for Oracle APEX API Reference
All content in Oracle APEX API Reference has been updated to reflect release 22.2 functionality.
New Features and Updates
The following topics have been added or updated for this release:
- APEX_APPROVALS (Updates)
- ADD_TO_HISTORY Procedure (New)
- SET_TASK_DUE Procedure (New)
- REQUEST_MORE_INFORMATION Procedure (New)
- SUBMIT_INFORMATION Procedure (New)
- RENEW_TASK Function (New)
- HANDLE_TASK_DEADLINES Procedure (New)
- GET_TASKS Function (Updated) - new parameter
p_show_expired_tasks
. - GET_TASK_HISTORY Function (Updated) - new parameter
p_include_all
.
- APEX_AUTOMATION (Updates)
EXECUTE
Procedure Signature 2 (New) - Executes an automation in the background.
- APEX_ESCAPE (Updates)
CSS_SELECTOR
Function (New)CSV
Function Signature 1 (New)CSV
Function Signature 2 (New)GET_CSV_ENCLOSED_BY
Function (New)GET_CSV_SEPARATED_BY
Function (New)HTML_ALLOWLIST_CLOB
Function (New)HTML_ATTRIBUTE_CLOB
Function (New)HTML_CLOB
Function (New)HTML_TRUNC
Function Signature 2 (New)JS_LITERAL_CLOB
Function (New)JSON_CLOB
Function (New)NOOP
Function Signature 2 (New)SET_CSV_PARAMETERS
Procedure (New)STRIPHTML
Function Signature 1 (New)STRIPHTML
Function Signature 2 (New)
The following APEX_ESCAPE APIs now use a deterministic syntax:
HTML
FunctionHTML_ALLOWLIST
FunctionHTML_ATTRIBUTE
Function
- APEX_EXEC (Updates)
ENQUOTE_LITERAL
Function (New)ENQUOTE_NAME
Function (New)
- APEX_INSTANCE_ADMIN (Updates)
SET_WORKSPACE_PARAMETER
Procedure (Updates) - New options forp_parameter
: ENV_BANNER_COLOR, ENV_BANNER_LABEL, ENV_BANNER_POS, and ENV_BANNER_YN.
- APEX_PLUGIN (Updates)
t_item_meta_data_result
Data Type (Updates) - new syntax includesescape_output
.
- APEX_PLUGIN_UTIL (Updates)
GET_ORDERBY_NULLS_SUPPORT
Function (New)GET_PLSQL_EXPR_RESULT_CLOB
Function (New)GET_PLSQL_FUNC_RESULT_CLOB
Function (New)PRINT_DISPLAY_ONLY
Procedure Signature 2 (New)PRINT_ESCAPED_VALUE
Procedure Signature 2 (New)PRINT_HIDDEN
Procedure (New)
- APEX_SEARCH (New) - new API package for application search.
SEARCH
Function (New)
- APEX_SESSION_STATE (New) - new API package utilities needed to read and assign session state values.
- Global Constants
- Data Types
GET_VARCHAR2
Function (New)GET_CLOB
Function (New)GET_NUMBER
Function (New)GET_TIMESTAMP
Function (New)GET_VALUE
Function (New)SET_VALUE
Procedure Signature 1 (New)SET_VALUE
Procedure Signature 2 (New)SET_VALUE
Procedure Signature 3 (New)
- APEX_UTIL (Updates)
BLOB_TO_CLOB
Function (New)CLOB_TO_BLOB
Function (New)GET_NUMERIC_SESSION_STATE
andGET_SESSION_STATE
Functions (Updates) - these functions can use FAST DUAL functionality for enhanced SQL query performance.
Deprecated and Desupported Features
The following APIs are deprecated as of this release:
APEX_INSTANCE_ADMIN.ADD_WEB_ENTRY_POINT
Procedure - The parameterp_methods
is deprecated.- APEX_LDAP Package - Port 389 is disabled. Use port 636 instead.
- APEX_PAGE - The following APIs are deprecated:
IS_DESKTOP_UI
FunctionGET_UI_TYPE
Function
See Deprecated Features and Desupported Features in Oracle APEX Release Notes .