1. API Reference
  2. Changes in Release 22.2 for Oracle APEX API Reference

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 Function
    • HTML_ALLOWLIST Function
    • HTML_ATTRIBUTE Function
  • APEX_EXEC (Updates)
    • ENQUOTE_LITERAL Function (New)
    • ENQUOTE_NAME Function (New)
  • APEX_INSTANCE_ADMIN (Updates)
    • SET_WORKSPACE_PARAMETER Procedure (Updates) - New options for p_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 includes escape_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 and GET_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 parameter p_methods is deprecated.
  • APEX_LDAP Package - Port 389 is disabled. Use port 636 instead.
  • APEX_PAGE - The following APIs are deprecated:
    • IS_DESKTOP_UI Function
    • GET_UI_TYPE Function

See Deprecated Features and Desupported Features in Oracle APEX Release Notes .