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

1 Changes in Release 23.2 for Oracle APEX API Reference

All content in Oracle APEX API Reference has been updated to reflect release 23.2 functionality.

New Features and Updates

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

  • APEX_APPLICATION_ADMIN (Updates)
    • Constants and Data Types - new constant t_storage_type.
    • GET_FILE_STORAGE Function (New)
    • SET_FILE_STORAGE Procedure (New)
  • APEX_APPROVAL (Updates)
    • Constants and Data Types (New)
    • GET_TASK_PARAMETER_OLD_VALUE Function (New)
    • HAS_TASK_PARAM_CHANGED Function (New)
    • REMOVE_POTENTIAL_OWNER Procedure (New)
    • SET_TASK_PARAMETER_VALUES Procedure (New)
  • APEX_BACKGROUND_PROCESS (Updates)
    • Constants - new constant c_status_terminated.
    • TERMINATE Procedure Signature 1 (New) - replaces ABORT procedure.
    • TERMINATE Procedure Signature 2 (New) - replaces ABORT procedure.
  • APEX_BARCODE (New) - support for barcode generation including QR codes.
    • GET_CODE128_PNG Function (New)
    • GET_CODE128_SVG Function (New)
    • GET_EAN8_PNG Function (New)
    • GET_EAN8_SVG Function (New)
    • GET_QRCODE_PNG Function (New)
    • GET_QRCODE_SVG Function (New)
  • APEX_ESCAPE (Updates)
    • HTML_ATTRIBUTE Function (Updated) - while not deprecated, recommendations added to use APEX_PLUGIN_UTIL.GET_HTML_ATTR instead.
  • APEX_HUMAN_TASK (New)
    • Constants and Data Types (New)
    • ADD_TASK_COMMENT Procedure (New)
    • ADD_TASK_POTENTIAL_OWNER Procedure (New)
    • ADD_TO_HISTORY Procedure (New)
    • APPROVE_TASK Procedure (New)
    • CANCEL_TASK Procedure (New)
    • CLAIM_TASK Procedure (New)
    • COMPLETE_TASK Procedure (New)
    • CREATE_TASK Function (New)
    • DELEGATE_TASK Procedure (New)
    • GET_LOV_PRIORITY Function (New)
    • GET_LOV_STATE Function (New)
    • GET_TASK_DELEGATES Function (New)
    • GET_TASK_HISTORY Function (New)
    • GET_TASK_PARAMETER_OLD_VALUE Function (New)
    • GET_TASK_PARAMETER_VALUE Function (New)
    • GET_TASK_PRIORITIES Function (New)
    • GET_TASKS Function (New)
    • HANDLE_TASK_DEADLINES Procedure (New)
    • HAS_TASK_PARAM_CHANGED Function (New)
    • IS_ALLOWED Function (New)
    • IS_BUSINESS_ADMIN Function (New)
    • IS_OF_PARTICIPANT_TYPE Function (New)
    • REJECT_TASK Procedure (New)
    • RELEASE_TASK Procedure (New)
    • REMOVE_POTENTIAL_OWNER Procedure (New)
    • RENEW_TASK Function (New)
    • REQUEST_MORE_INFORMATION Procedure (New)
    • SET_TASK_DUE Procedure (New)
    • SET_TASK_PARAMETER_VALUES Procedure (New)
    • SET_TASK_PRIORITY Procedure (New)
    • SUBMIT_INFORMATION Procedure (New)
  • APEX_INSTANCE_ADMIN (Updates)
    • Available Parameter Values - new parameters DISABLE_APPS_LOGIN and RESTRICT_APPS_HEADER.
    • CREATE_OR_UPDATE_ADMIN_USER Procedure (New)
    • UNLOCK_USER Procedure (New)
  • APEX_IR (Updates)
    • CLONE_REPORT Function (New)
    • EXPORT_SAVED_REPORTS Function (New)
    • IMPORT_SAVED_REPORTS Procedure (New)
  • APEX_PLUGIN_UTIL (Updates)
    • GET_HTML_ATTR Function (New) - new API for enhanced support for screen readers.
  • APEX_WEB_SERVICE (Updates)
    • Global Variables (New)
    • BLOB2CLOBBASE64 Function (Updates) - new parameters p_newlines and p_padding.
  • APEX_WORKFLOW (New)
    • Constants and Data Types (New)
    • CONTINUE_ACTIVITY Procedure Signature 1 (New)
    • CONTINUE_ACTIVITY Procedure Signature 2 (New)
    • GET_LOV_ACTIVITY_STATE Function (New)
    • GET_LOV_WORKFLOW_STATE Function (New)
    • GET_VARIABLE_VALUE Function (New)
    • GET_WORKFLOW_STATE Function (New)
    • GET_WORKFLOWS Function (New)
    • IS_ADMIN Function (New)
    • IS_ALLOWED Function (New)
    • IS_OF_PARTICIPANT_TYPE Function (New)
    • REFRESH_PARTICIPANTS Procedure (New)
    • REMOVE_DEVELOPMENT_INSTANCES Procedure (New)
    • RESUME Procedure (New)
    • RETRY Procedure (New)
    • SET_LOG_LEVEL Procedure (New)
    • START_WORKFLOW Function (New)
    • SUSPEND Procedure (New)
    • TERMINATE Procedure (New)
    • TERMINATE_FAULTED_WORKFLOWS Procedure (New)
    • UPDATE_VARIABLES Procedure (New)

Deprecated and Desupported Features

The following APIs are deprecated as of this release:

  • APEX_BACKGROUND_PROCESS
    • ABORT Procedure Signature 1 (Deprecated)
    • ABORT Procedure Signature 2 (Deprecated)
  • APEX_CSS
    • ADD_3RD_PARTY_LIBRARY_FILE Procedure (Deprecated)
  • APEX_JAVASCRIPT
    • ADD_3RD_PARTY_LIBRARY_FILE Procedure (Deprecated)

The following APIs are desupported as of this release:

  • APEX_PAGE
    • IS_JQM_SMARTPHONE_UI Function
    • IS_JQM_TABLET_UI Function

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