1. API Reference
  2. Changes in Release 20.1 for Oracle Application Express API Reference

1 Changes in Release 20.1 for Oracle Application Express API Reference

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

New Features and Updates

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

  • APEX_AUTHENTICATION (Updated)

    • SEND_LOGIN_USERNAME_COOKIE - Updated p_consent description.

    • PERSISTENT_COOKIES_ENABLED Function - The new function returns whether persistent cookies are enabled on the instance.

    See "APEX_AUTHENTICATION."

  • APEX_IG (New)

    • ADD_FILTER Procedure Signature 1 - New procedure that creates a filter on an interactive grid using a report ID.

    • ADD_FILTER Procedure Signature 1 - New procedure that creates a filter on an interactive grid using a report name.

    • CHANGE_REPORT_OWNER Procedure - New procedure that changes the owner of a saved interactive grid report using a report ID. This procedure cannot change the owner of default interactive grid report.

    • CLEAR_REPORT Procedure Signature 1 - New procedure that clears report filter settings to the developer defined default settings using the report ID.

    • CLEAR_REPORT Procedure Signature 1 - New procedure that clears filter report settings to the developer defined default settings using the report name.

    • DELETE_REPORT Procedure - New procedure that deletes a saved interactive grid report. It deletes a specific saved report in the current logged in workspace and application.

    • GET_LAST_VIEWED_REPORT_ID Function - New function that returns the last viewed base report ID of the specified page and region.

    • RESET_REPORT Procedure Signature 1 - New procedure that resets report settings to the developer defined default settings using the report ID.

    • RESET_REPORT Procedure Signature 2 - New procedure that resets report settings to the developer defined default settings using the report name.

    See "APEX_IG."

  • APEX_STRING_UTIL (New)

    • REPLACE_WHITESPACE Function - This function can be used to tokenize the input

    • FIND_FILE_EXTENSION Function - This function returns a file name's extension.

    • FIND_PHRASE Function - This function returns whether the given phrase is in p_string.

    • FIND_PHRASES Function - This function finds the occurrences of p_string in p_phrase return in an array.

    • FIND_EMAIL_ADDRESSES Function - This function finds all email addresses in the given input string.

    • FIND_EMAIL_FROM Function - This function Finds first occurrance of "From: " and the first email after the "From:".

    • FIND_EMAIL_SUBJECT Function - This function finds the subject text in a given email string.

    • FIND_TAGS Function - This function finds all strings prefixed with a tag identifier.

    • FIND_LINKS Function - This function finds https and http hypertext links within text.

    • GET_DOMAIN Function - This function extracts a domain from a link or email.

    • FIND_IDENTIFIERS Function - Given an identifiers prefix, this function finds the identifiers including consecutive numbers following.

    • TO_DISPLAY_FILESIZE Function - This function returns a friendly file size, given a size in bytes (for example, 5.1MB or 6GB).

    • TO_SLUG Function - Use this function to convert the input string to a "-" separated string, with special characters removed.

    See "APEX_STRING_UTIL."

  • APEX_INSTANCE_ADMIN (Updated) - Added the following new parameters:

    • WORKSPACE_NAME_USER_COOKIE

    • PASSWORD_NOT_LIKE_USERNAME

    • PASSWORD_NOT_LIKE_WORDS

    • PASSWORD_NOT_LIKE_WS_NAME

    • PASSWORD_ONE_ALPHA

    • PASSWORD_ONE_LOWER_CASE

    • PASSWORD_ONE_NUMERIC

    • PASSWORD_ONE_PUNCTUATION

    • PASSWORD_ONE_UPPER_CASE

    • SERVICE_ADMIN_PASSWORD_MIN_LENGTH

    • SERVICE_ADMIN_PASSWORD_NEW_DIFFERS_BY

    • SERVICE_ADMIN_PASSWORD_ONE_ALPHA

    • SERVICE_ADMIN_PASSWORD_ONE_NUMERIC

    • SERVICE_ADMIN_PASSWORD_ONE_PUNCTUATION

    • SERVICE_ADMIN_PASSWORD_ONE_UPPER_CASE

    • SERVICE_ADMIN_PASSWORD_ONE_LOWER_CASE

    • SERVICE_ADMIN_PASSWORD_NOT_LIKE_USERNAME

    • SERVICE_ADMIN_PASSWORD_NOT_LIKE_WS_NAME

    • SERVICE_ADMIN_PASSWORD_NOT_LIKE_WORDS

    See "Available Parameter Values" in "APEX_INSTANCE_ADMIN."

  • APEX_JSON (Updated)

    • GET_CLOB_OUTPUT - This new function returns the temporary CLOB that you created with INITIALIZE_CLOB_OUTPUT.

    See "GET_CLOB_OUTPUT Function."

Deprecated and Desupported Features

  • OAUTH_AUTHENTICATE Procedure Signature 2 has been deprecated because p_wallet_path and p_wallet_pwd do not have a default value. Oracle recommends using OAUTH_AUTHENTICATE_CREDENTIAL instead.

    See "OAUTH_AUTHENTICATE_CREDENTIAL."

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