Contents

Beta Draft: 2016-09-09

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 5.1
  • New Features
  • Deprecated and Desupported Features

1 APEX_APPLICATION

• 1.1 Global Variables
• 1.2 Referencing Arrays
• 1.3 Referencing Values Within an On Submit Process
• 1.4 Converting an Array to a Single Value
• 1.5 HELP Procedure
• 1.6 STOP_APEX_ENGINE Procedure

2 APEX_APPLICATION_INSTALL

• 2.1 Package Overview
• 2.2 Attributes Manipulated by APEX_APPLICATION_INSTALL
• 2.3 Import Script Examples
• 2.4 CLEAR_ALL Procedure
• 2.5 GENERATE_APPLICATION_ID Procedure
• 2.6 GENERATE_OFFSET Procedure
• 2.7 GET_APPLICATION_ALIAS Function
• 2.8 GET_APPLICATION_ID Function
• 2.9 GET_APPLICATION_NAME Function
• 2.10 GET_AUTO_INSTALL_SUP_OBJ Function
• 2.11 GET_IMAGE_PREFIX Function
• 2.12 GET_OFFSET Function
• 2.13 GET_PROXY Function
• 2.14 GET_SCHEMA Function
• 2.15 GET_WORKSPACE_ID Function
• 2.16 SET_APPLICATION_ALIAS Procedure
• 2.17 SET_APPLICATION_ID Procedure
• 2.18 SET_APPLICATION_NAME Procedure
• 2.19 SET_AUTO_INSTALL_SUP_OBJ Procedure
• 2.20 SET_IMAGE_PREFIX Procedure
• 2.21 SET_OFFSET Procedure
• 2.22 SET_PROXY Procedure
• 2.23 SET_SCHEMA Procedure
• 2.24 SET_WORKSPACE_ID Procedure
• 2.25 SET_WORKSPACE_Procedure

3 APEX_AUTHENTICATION

• 3.1 Constants
• 3.2 CALLBACK Procedure
• 3.3 GET_CALLBACK_URL Function
• 3.4 GET_LOGIN_USERNAME_COOKIE Function
• 3.5 IS_AUTHENTICATED Function
• 3.6 IS_PUBLIC_USER Function
• 3.7 LOGIN Procedure
• 3.8 LOGOUT Procedure
• 3.9 POST_LOGIN Procedure
• 3.10 SEND_LOGIN_USERNAME_COOKIE Procedure

4 APEX_AUTHORIZATION

• 4.1 ENABLE_DYNAMIC_GROUPS Procedure
• 4.2 IS_AUTHORIZED Function
• 4.3 RESET_CACHE Procedure

5 APEX_SESSION

• 5.1 SET_DEBUG Procedure
• 5.2 SET_TRACE Procedure

6 APEX_COLLECTION

• 6.1 About the APEX_COLLECTION API
• 6.2 Naming Collections
• 6.3 Creating a Collection
• 6.4 About the Parameter p_generate_md5
• 6.5 Accessing a Collection
• 6.6 Merging Collections
• 6.7 Truncating a Collection
• 6.8 Deleting a Collection
• 6.9 Deleting All Collections for the Current Application
• 6.10 Deleting All Collections in the Current Session
• 6.11 Adding Members to a Collection
• 6.12 About the Parameters p_generate_md5, p_clob001, p_blob001, and p_xmltype001
• 6.13 Updating Collection Members
• 6.14 Deleting Collection Members
• 6.15 Obtaining a Member Count
• 6.16 Resequencing a Collection
• 6.17 Verifying Whether a Collection Exists
• 6.18 Adjusting a Member Sequence ID
• 6.19 Sorting Collection Members
• 6.20 Clearing Collection Session State
• 6.21 Determining Collection Status
• 6.22 ADD_MEMBER Procedure
• 6.23 ADD_MEMBER Function
• 6.24 ADD_MEMBERS Procedure
• 6.25 COLLECTION_EXISTS Function
• 6.26 COLLECTION_HAS_CHANGED Function
• 6.27 COLLECTION_MEMBER_COUNT Function
• 6.28 CREATE_COLLECTION Procedure
• 6.29 CREATE_OR_TRUNCATE_COLLECTION Procedure
• 6.30 CREATE_COLLECTION_FROM_QUERY Procedure
• 6.31 CREATE_COLLECTION_FROM_QUERY2 Procedure
• 6.32 CREATE_COLLECTION_FROM_QUERY_B Procedure
• 6.33 CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
• 6.34 CREATE_COLLECTION_FROM_QUERYB2 Procedure
• 6.35 CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
• 6.36 DELETE_ALL_COLLECTIONS Procedure
• 6.37 DELETE_ALL_COLLECTIONS_SESSION Procedure
• 6.38 DELETE_COLLECTION Procedure
• 6.39 DELETE_MEMBER Procedure
• 6.40 DELETE_MEMBERS Procedure
• 6.41 GET_MEMBER_MD5 Function
• 6.42 MERGE_MEMBERS Procedure
• 6.43 MOVE_MEMBER_DOWN Procedure
• 6.44 MOVE_MEMBER_UP Procedure
• 6.45 RESEQUENCE_COLLECTION Procedure
• 6.46 RESET_COLLECTION_CHANGED Procedure
• 6.47 RESET_COLLECTION_CHANGED_ALL Procedure
• 6.48 SORT_MEMBERS Procedure
• 6.49 TRUNCATE_COLLECTION Procedure
• 6.50 UPDATE_MEMBER Procedure
• 6.51 UPDATE_MEMBERS Procedure
• 6.52 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
• 6.53 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
• 6.54 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
• 6.55 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
• 6.56 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
• 6.57 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6

7 APEX_CSS

• 7.1 ADD Procedure
• 7.2 ADD_3RD_PARTY_LIBRARY_FILE Procedure
• 7.3 ADD_FILE Procedure

8 APEX_CUSTOM_AUTH

• 8.1 APPLICATION_PAGE_ITEM_EXISTS Function
• 8.2 CURRENT_PAGE_IS_PUBLIC Function
• 8.3 DEFINE_USER_SESSION Procedure
• 8.4 GET_COOKIE_PROPS Procedure
• 8.5 GET_LDAP_PROPS Procedure
• 8.6 GET_NEXT_SESSION_ID Function
• 8.7 GET_SECURITY_GROUP_ID Function
• 8.8 GET_SESSION_ID Function
• 8.9 GET_SESSION_ID_FROM_COOKIE Function
• 8.10 GET_USER Function
• 8.11 GET_USERNAME Function
• 8.12 IS_SESSION_VALID Function
• 8.13 LOGIN Procedure
• 8.14 LOGOUT Procedure [DEPRECATED]
• 8.15 POST_LOGIN Procedure
• 8.16 SESSION_ID_EXISTS Function
• 8.17 SET_SESSION_ID Procedure
• 8.18 SET_SESSION_ID_TO_NEXT_VALUE Procedure
• 8.19 SET_USER Procedure

9 APEX_DEBUG

• 9.1 Constants
• 9.2 APEX_DEBUG.DISABLE Procedure
• 9.3 APEX_DEBUG.ENABLE Procedure
• 9.4 ENTER Procedure
• 9.5 ERROR Procedure
• 9.6 INFO Procedure
• 9.7 LOG_DBMS_OUTPUT Procedure
• 9.8 LOG_LONG_MESSAGE Procedure
• 9.9 LOG_MESSAGE Procedure [Deprecated]
• 9.10 LOG_PAGE_SESSION_STATE Procedure
• 9.11 MESSAGE Procedure
• 9.12 REMOVE_DEBUG_BY_AGE Procedure
• 9.13 REMOVE_DEBUG_BY_APP Procedure
• 9.14 REMOVE_DEBUG_BY_VIEW Procedure
• 9.15 REMOVE_SESSION_MESSAGES Procedure
• 9.16 TOCHAR Function
• 9.17 TRACE Procedure
• 9.18 WARN Procedure

10 APEX_ERROR

• 10.1 Constants and Attributes used for Result Types
• 10.2 Example of an Error Handling Function
• 10.3 ADD_ERROR Procedure Signature 1
• 10.4 ADD_ERROR Procedure Signature 2
• 10.5 ADD_ERROR Procedure Signature 3
• 10.6 ADD_ERROR Procedure Signature 4
• 10.7 ADD_ERROR Procedure Signature 5
• 10.8 AUTO_SET_ASSOCIATED_ITEM Procedure
• 10.9 EXTRACT_CONSTRAINT_NAME Function
• 10.10 GET_ARIA_ERROR_ATTRIBUTES Function
• 10.11 GET_FIRST_ORA_ERROR_TEXT Function
• 10.12 INIT_ERROR_RESULT Function

11 APEX_ESCAPE

• 11.1 Constants
• 11.2 HTML Function
• 11.3 HTML_ATTRIBUTE Function
• 11.4 HTML_TRUNC Function
• 11.5 HTML_WHITELIST Function
• 11.6 JS_LITERAL Function
• 11.7 JSON Function
• 11.8 LDAP_DN Function
• 11.9 LDAP_SEARCH_FILTER Function
• 11.10 NOOP Function
• 11.11 REGEXP Function
• 11.12 SET_HTML_ESCAPING_MODE Procedure

12 APEX_INSTANCE_ADMIN

• 12.1 Available Parameter Values
• 12.2 ADD_SCHEMA Procedure
• 12.3 ADD_WORKSPACE Procedure
• 12.4 CREATE_SCHEMA_EXCEPTION Procedure
• 12.5 FREE_WORKSPACE_APP_IDS Procedure
• 12.6 GET_PARAMETER Function
• 12.7 GET_SCHEMAS Function
• 12.8 GET_WORKSPACE_PARAMETER
• 12.9 REMOVE_APPLICATION Procedure
• 12.10 REMOVE_SAVED_REPORT Procedure
• 12.11 REMOVE_SAVED_REPORTS Procedure
• 12.12 REMOVE_SCHEMA Procedure
• 12.13 REMOVE_SCHEMA_EXCEPTION Procedure
• 12.14 REMOVE_SCHEMA_EXCEPTIONS Procedure
• 12.15 REMOVE_SUBSCRIPTION Procedure
• 12.16 REMOVE_WORKSPACE Procedure
• 12.17 REMOVE_WORKSPACE_EXCEPTIONS Procedure
• 12.18 RESERVE_WORKSPACE_APP_IDS Procedure
• 12.19 RESTRICT_SCHEMA Procedure
• 12.20 SET_LOG_SWITCH_INTERVAL Procedure
• 12.21 SET_WORKSPACE_PARAMETER
• 12.22 SET_PARAMETER Procedure
• 12.23 SET_WORKSPACE_CONSUMER_GROUP Procedure
• 12.24 TRUNCATE_LOG Procedure
• 12.25 UNRESTRICT_SCHEMA Procedure

13 APEX_IR

• 13.1 ADD_FILTER Procedure Signature 1
• 13.2 ADD_FILTER Procedure Signature 2
• 13.3 CHANGE_SUBSCRIPTION_EMAIL Procedure
• 13.4 CHANGE_REPORT_OWNER Procedure
• 13.5 CHANGE_SUBSCRIPTION_EMAIL Procedure
• 13.6 CHANGE_SUBSCRIPTION_LANG Procedure
• 13.7 CLEAR_REPORT Procedure Signature 1
• 13.8 CLEAR_REPORT Procedure Signature 2
• 13.9 DELETE_REPORT Procedure
• 13.10 DELETE_SUBSCRIPTION Procedure
• 13.11 GET_LAST_VIEWED_REPORT_ID Function
• 13.12 GET_REPORT Function
• 13.13 RESET_REPORT Procedure Signature 1
• 13.14 RESET_REPORT Procedure Signature 2

14 APEX_ITEM

• 14.1 CHECKBOX2 Function
• 14.2 DATE_POPUP Function
• 14.3 DATE_POPUP2 Function
• 14.4 DISPLAY_AND_SAVE Function
• 14.5 HIDDEN Function
• 14.6 MD5_CHECKSUM Function
• 14.7 MD5_HIDDEN Function
• 14.8 POPUP_FROM_LOV Function
• 14.9 POPUP_FROM_QUERY Function
• 14.10 POPUPKEY_FROM_LOV Function
• 14.11 POPUPKEY_FROM_QUERY Function
• 14.12 RADIOGROUP Function
• 14.13 SELECT_LIST Function
• 14.14 SELECT_LIST_FROM_LOV Function
• 14.15 SELECT_LIST_FROM_LOV_XL Function
• 14.16 SELECT_LIST_FROM_QUERY Function
• 14.17 SELECT_LIST_FROM_QUERY_XL Function
• 14.18 SWITCH Function
• 14.19 TEXT Function
• 14.20 TEXTAREA Function
• 14.21 TEXT_FROM_LOV Function
• 14.22 TEXT_FROM_LOV_QUERY Function

15 APEX_JAVASCRIPT

• 15.1 ADD_3RD_PARTY_LIBRARY_FILE Procedure
• 15.2 ADD_ATTRIBUTE Function Signature 1
• 15.3 ADD_ATTRIBUTE Function Signature 2
• 15.4 ADD_ATTRIBUTE Function Signature 3
• 15.5 ADD_ATTRIBUTE Function Signature 4
• 15.6 ADD_INLINE_CODE Procedure
• 15.7 ADD_LIBRARY Procedure
• 15.8 ADD_ONLOAD_CODE Procedure
• 15.9 ADD_VALUE Function Signature 1
• 15.10 ADD_VALUE Function Signature 2
• 15.11 ADD_VALUE Function Signature 3
• 15.12 ADD_VALUE Function Signature 4
• 15.13 Escape Function

16 APEX_JSON

• 16.1 Package Overview and Examples
• 16.2 Constants and Data Types
• 16.3 CLOSE_ALL Procedure
• 16.4 CLOSE_ARRAY Procedure
• 16.5 CLOSE_OBJECT Procedure
• 16.6 DOES_EXIST Function
• 16.7 FIND_PATHS_LIKE Function
• 16.8 FREE_OUTPUT Procedure
• 16.9 FLUSH Procedure
• 16.10 GET_BOOLEAN Function
• 16.11 GET_CLOB_OUTPUT Function
• 16.12 GET_COUNT Function
• 16.13 GET_DATE Function
• 16.14 GET_MEMBERS Function
• 16.15 GET_NUMBER Function
• 16.16 GET_VALUE Function
• 16.17 GET_VARCHAR2 Function
• 16.18 INITIALIZE_CLOB_OUTPUT Procedure
• 16.19 INITIALIZE_OUTPUT Procedure
• 16.20 OPEN_ARRAY Procedure
• 16.21 OPEN_OBJECT Procedure
• 16.22 PARSE Procedure Signature 1
• 16.23 PARSE Procedure Signature 2
• 16.24 STRINGIFY Function Signature 1
• 16.25 STRINGIFY Function Signature 2
• 16.26 STRINGIFY Function Signature 3
• 16.27 STRINGIFY Function Signature 4
• 16.28 TO_XMLTYPE Function
• 16.29 WRITE Procedure Signature 1
• 16.30 WRITE Procedure Signature 2
• 16.31 WRITE Procedure Signature 3
• 16.32 WRITE Procedure Signature 4
• 16.33 WRITE Procedure Signature 5
• 16.34 WRITE Procedure Signature 6
• 16.35 WRITE Procedure Signature 7
• 16.36 WRITE Procedure Signature 8
• 16.37 WRITE Procedure Signature 9
• 16.38 WRITE Procedure Signature 10
• 16.39 WRITE Procedure Signature 11
• 16.40 WRITE Procedure Signature 12
• 16.41 WRITE Procedure Signature 13
• 16.42 WRITE Procedure Signature 14
• 16.43 WRITE Procedure Signature 15
• 16.44 WRITE Procedure Signature 16
• 16.45 WRITE Procedure Signature 17
• 16.46 WRITE Procedure Signature 18

17 APEX_LANG

• 17.1 CREATE_LANGUAGE_MAPPING Procedure
• 17.2 DELETE_LANGUAGE_MAPPING Procedure
• 17.3 LANG Function
• 17.4 MESSAGE Function
• 17.5 PUBLISH_APPLICATION Procedure
• 17.6 SEED_TRANSLATIONS Procedure
• 17.7 UPDATE_LANGUAGE_MAPPING Procedure
• 17.8 UPDATE_MESSAGE Procedure
• 17.9 UPDATE_TRANSLATED_STRING Procedure

18 APEX_LDAP

• 18.1 AUTHENTICATE Function
• 18.2 GET_ALL_USER_ATTRIBUTES Procedure
• 18.3 GET_USER_ATTRIBUTES Procedure
• 18.4 IS_MEMBER Function
• 18.5 MEMBER_OF Function
• 18.6 MEMBER_OF2 Function
• 18.7 APEX_LDAP.SEARCH Function

19 APEX_MAIL

• 19.1 Configuring Oracle Application Express to Send Email
• 19.2 ADD_ATTACHMENT Procedure
• 19.3 GET_IMAGES_URL Function
• 19.4 GET_INSTANCE_URL Function
• 19.5 PUSH_QUEUE Procedure
• 19.6 SEND Procedure

20 APEX_PAGE

• 20.1 Global Constants
• 20.2 IS_DESKTOP_UI Function
• 20.3 IS_JQM_SMARTPHONE_UI Function
• 20.4 IS_JQM_TABLET_UI Function
• 20.5 GET_UI_TYPE Function
• 20.6 IS_READ_ONLY Function
• 20.7 GET_PAGE_MODE Function
• 20.8 PURGE_CACHE Procedure
• 20.9 GET_URL Function

21 APEX_PLUGIN

• 21.1 Data Types
• 21.2 GET_AJAX_IDENTIFIER Function
• 21.3 GET_INPUT_NAME_FOR_PAGE_ITEM Function

22 APEX_PLUGIN_UTIL

• 22.1 DEBUG_DYNAMIC _ACTION Procedure
• 22.2 DEBUG_PAGE_ITEM Procedure Signature 1
• 22.3 DEBUG_PAGE_ITEM Procedure Signature 2
• 22.4 DEBUG_PROCESS Procedure
• 22.5 DEBUG_REGION Procedure Signature 1
• 22.6 DEBUG_REGION Procedure Signature 2
• 22.7 ESCAPE Function
• 22.8 EXECUTE_PLSQL_CODE Procedure
• 22.9 GET_ATTRIBUTE_AS_NUMBER Function
• 22.10 GET_DATA Function Signature 1
• 22.11 GET_DATA Function Signature 2
• 22.12 GET_DATA2 Function Signature 1
• 22.13 GET_DATA2 Function Signature 2
• 22.14 GET_DISPLAY_DATA Function Signature 1
• 22.15 GET_DISPLAY_DATA Function Signature 2
• 22.16 GET_ELEMENT_ATTRIBUTES Function
• 22.17 GET_PLSQL_EXPRESSION_RESULT Function
• 22.18 GET_PLSQL_FUNCTION_RESULT Function
• 22.19 GET_POSITION_IN_LIST Function
• 22.20 GET_SEARCH_STRING Function
• 22.21 GET_VALUE_AS_VARCHAR2 Function
• 22.22 IS_EQUAL Function
• 22.23 PAGE_ITEM_NAMES_TO_JQUERY Function
• 22.24 PRINT_DISPLAY_ONLY Procedure
• 22.25 PRINT_ESCAPED_VALUE Procedure
• 22.26 PRINT_HIDDEN_IF_READONLY Procedure
• 22.27 PRINT_JSON_HTTP_HEADER Procedure
• 22.28 PRINT_LOV_AS_JSON Procedure
• 22.29 PRINT_OPTION Procedure
• 22.30 REPLACE_SUBSTITUTIONS Function

23 APEX_REGION

• 23.1 IS_READ_ONLY Function
• 23.2 PURGE_CACHE Procedure

24 APEX_SPATIAL

• 24.1 Data Types
• 24.2 CHANGE_GEOM_METADATA Procedure
• 24.3 CIRCLE_POLYGON Function
• 24.4 DELETE_GEOM_METADATA Procedure
• 24.5 INSERT_GEOM_METADATA Procedure
• 24.6 INSERT_GEOM_METADATA_LONLAT Procedure
• 24.7 POINT Function
• 24.8 RECTANGLE Function

25 APEX_THEME

• 25.1 SET_CURRENT_STYLE Procedure
• 25.2 SET_SESSION_STYLE Procedure
• 25.3 SET_SESSION_STYLE_CSS Procedure
• 25.4 SET_USER_STYLE Procedure
• 25.5 GET_USER_STYLE Function
• 25.6 CLEAR_USER_STYLE Procedure
• 25.7 CLEAR_ALL_USERS_STYLE Procedure
• 25.8 ENABLE_USER_STYLE Procedure
• 25.9 DISABLE_USER_STYLE Procedure

26 APEX_UI_DEFAULT_UPDATE

• 26.1 ADD_AD_COLUMN Procedure
• 26.2 ADD_AD_SYNONYM Procedure
• 26.3 DEL_AD_COLUMN Procedure
• 26.4 DEL_AD_SYNONYM Procedure
• 26.5 DEL_COLUMN Procedure
• 26.6 DEL_GROUP Procedure
• 26.7 DEL_TABLE Procedure
• 26.8 SYNCH_TABLE Procedure
• 26.9 UPD_AD_COLUMN Procedure
• 26.10 UPD_AD_SYNONYM Procedure
• 26.11 UPD_COLUMN Procedure
• 26.12 UPD_DISPLAY_IN_FORM Procedure
• 26.13 UPD_DISPLAY_IN_REPORT Procedure
• 26.14 UPD_FORM_REGION_TITLE Procedure
• 26.15 UPD_GROUP Procedure
• 26.16 UPD_ITEM_DISPLAY_HEIGHT Procedure
• 26.17 UPD_ITEM_DISPLAY_WIDTH Procedure
• 26.18 UPD_ITEM_FORMAT_MASK Procedure
• 26.19 UPD_ITEM_HELP Procedure
• 26.20 UPD_LABEL Procedure
• 26.21 UPD_REPORT_ALIGNMENT Procedure
• 26.22 UPD_REPORT_FORMAT_MASK Procedure
• 26.23 UPD_REPORT_REGION_TITLE Procedure
• 26.24 UPD_TABLE Procedure

27 APEX_UTIL

• 27.1 CACHE_GET_DATE_OF_PAGE_CACHE Function
• 27.2 CACHE_GET_DATE_OF_REGION_CACHE Function
• 27.3 CACHE_PURGE_BY_APPLICATION Procedure
• 27.4 CACHE_PURGE_BY_PAGE Procedure
• 27.5 CACHE_PURGE_STALE Procedure
• 27.6 CHANGE_CURRENT_USER_PW Procedure
• 27.7 CHANGE_PASSWORD_ON_FIRST_USE Function
• 27.8 CLOSE_OPEN_DB_LINKS Procedure
• 27.9 CLEAR_APP_CACHE Procedure
• 27.10 CLEAR_PAGE_CACHE Procedure
• 27.11 CLEAR_USER_CACHE Procedure
• 27.12 COUNT_CLICK Procedure
• 27.13 CREATE_USER Procedure
• 27.14 CREATE_USER_GROUP Procedure
• 27.15 CURRENT_USER_IN_GROUP Function
• 27.16 CUSTOM_CALENDAR Procedure
• 27.17 DELETE_USER_GROUP Procedure Signature 1
• 27.18 DELETE_USER_GROUP Procedure Signature 2
• 27.19 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
• 27.20 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
• 27.21 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
• 27.22 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
• 27.23 EDIT_USER Procedure
• 27.24 END_USER_ACCOUNT_DAYS_LEFT Function
• 27.25 EXPIRE_END_USER_ACCOUNT Procedure
• 27.26 EXPIRE_WORKSPACE_ACCOUNT Procedure
• 27.27 EXPORT_USERS Procedure
• 27.28 FETCH_APP_ITEM Function
• 27.29 FETCH_USER Procedure Signature 1
• 27.30 FETCH_USER Procedure Signature 2
• 27.31 FETCH_USER Procedure Signature 3
• 27.32 FIND_SECURITY_GROUP_ID Function
• 27.33 FIND_WORKSPACE Function
• 27.34 GET_ACCOUNT_LOCKED_STATUS Function
• 27.35 GET_ATTRIBUTE Function
• 27.36 GET_AUTHENTICATION_RESULT Function
• 27.37 GET_BLOB_FILE_SRC Function
• 27.38 GET_BUILD_OPTION_STATUS Function Signature 1
• 27.39 GET_BUILD_OPTION_STATUS Function Signature 2
• 27.40 GET_CURRENT_USER_ID Function
• 27.41 GET_DEFAULT_SCHEMA Function
• 27.42 GET_EDITION Function
• 27.43 GET_EMAIL Function
• 27.44 GET_FEEDBACK_FOLLOW_UP Function
• 27.45 GET_FILE Procedure
• 27.46 GET_FILE_ID Function
• 27.47 GET_FIRST_NAME Function
• 27.48 GET_GROUPS_USER_BELONGS_TO Function
• 27.49 GET_GROUP_ID Function
• 27.50 GET_GROUP_NAME Function
• 27.51 GET_HASH Function
• 27.52 GET_HIGH_CONTRAST_MODE_TOGGLE Function
• 27.53 GET_LAST_NAME Function
• 27.54 GET_NUMERIC_SESSION_STATE Function
• 27.55 GET_PREFERENCE Function
• 27.56 GET_PRINT_DOCUMENT Function Signature 1
• 27.57 GET_PRINT_DOCUMENT Function Signature 2
• 27.58 GET_PRINT_DOCUMENT Function Signature 3
• 27.59 GET_PRINT_DOCUMENT Function Signature 4
• 27.60 GET_SCREEN_READER_MODE_TOGGLE Function
• 27.61 GET_SESSION_LANG Function
• 27.62 GET_SESSION_STATE Function
• 27.63 GET_SESSION_TERRITORY Function
• 27.64 GET_SESSION_TIME_ZONE Function
• 27.65 GET_SINCE Function
• 27.66 GET_USER_ID Function
• 27.67 GET_USER_ROLES Function
• 27.68 GET_USERNAME Function
• 27.69 HOST_URL Function
• 27.70 HTML_PCT_GRAPH_MASK Function
• 27.71 INCREMENT_CALENDAR Procedure
• 27.72 IR_CLEAR Procedure [DEPRECATED]
• 27.73 IR_DELETE_REPORT Procedure [DEPRECATED]
• 27.74 IR_DELETE_SUBSCRIPTION Procedure [DEPRECATED]
• 27.75 IR_FILTER Procedure [DEPRECATED]
• 27.76 IR_RESET Procedure [DEPRECATED]
• 27.77 IS_HIGH_CONTRAST_SESSION Function
• 27.78 IS_HIGH_CONTRAST_SESSION_YN Function
• 27.79 IS_LOGIN_PASSWORD_VALID Function
• 27.80 IS_SCREEN_READER_SESSION Function
• 27.81 IS_SCREEN_READER_SESSION_YN Function
• 27.82 IS_USERNAME_UNIQUE Function
• 27.83 KEYVAL_NUM Function
• 27.84 KEYVAL_VC2 Function
• 27.85 LOCK_ACCOUNT Procedure
• 27.86 PASSWORD_FIRST_USE_OCCURRED Function
• 27.87 PREPARE_URL Function
• 27.88 PUBLIC_CHECK_AUTHORIZATION Function [DEPRECATED]
• 27.89 PURGE_REGIONS_BY_APP Procedure
• 27.90 PURGE_REGIONS_BY_NAME Procedure
• 27.91 PURGE_REGIONS_BY_PAGE Procedure
• 27.92 REDIRECT_URL Procedure
• 27.93 REMOVE_PREFERENCE Procedure
• 27.94 REMOVE_SORT_PREFERENCES Procedure
• 27.95 REMOVE_USER Procedure
• 27.96 RESET_AUTHORIZATIONS Procedure [DEPRECATED]
• 27.97 RESET_PASSWORD Procedure
• 27.98 RESET_PW Procedure
• 27.99 SAVEKEY_NUM Function
• 27.100 SAVEKEY_VC2 Function
• 27.101 SET_ATTRIBUTE Procedure
• 27.102 SET_AUTHENTICATION_RESULT Procedure
• 27.103 SET_BUILD_OPTION_STATUS Procedure
• 27.104 SET_CURRENT_THEME_STYLE Procedure [DEPRECATED]
• 27.105 SET_CUSTOM_AUTH_STATUS Procedure
• 27.106 SET_EDITION Procedure
• 27.107 SET_EMAIL Procedure
• 27.108 SET_FIRST_NAME Procedure
• 27.109 SET_GROUP_GROUP_GRANTS Procedure
• 27.110 SET_GROUP_USER_GRANTS Procedure
• 27.111 SET_LAST_NAME Procedure
• 27.112 SET_PREFERENCE Procedure
• 27.113 SET_SECURITY_GROUP_ID Procedure
• 27.114 SET_SESSION_HIGH_CONTRAST_OFF Procedure
• 27.115 SET_SESSION_HIGH_CONTRAST_ON Procedure
• 27.116 SET_SESSION_LANG Procedure
• 27.117 SET_SESSION_LIFETIME_SECONDS Procedure
• 27.118 SET_SESSION_MAX_IDLE_SECONDS Procedure
• 27.119 SET_SESSION_SCREEN_READER_OFF Procedure
• 27.120 SET_SESSION_SCREEN_READER_ON Procedure
• 27.121 SET_SESSION_STATE Procedure
• 27.122 SET_SESSION_TERRITORY Procedure
• 27.123 SET_SESSION_TIME_ZONE Procedure
• 27.124 SET_USERNAME Procedure
• 27.125 SET_WORKSPACE_Procedure
• 27.126 SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
• 27.127 SHOW_SCREEN_READER_MODE_TOGGLE Procedure
• 27.128 STRING_TO_TABLE Function
• 27.129 STRONG_PASSWORD_CHECK Procedure
• 27.130 STRONG_PASSWORD_VALIDATION Function
• 27.131 SUBMIT_FEEDBACK Procedure
• 27.132 SUBMIT_FEEDBACK_FOLLOWUP Procedure
• 27.133 TABLE_TO_STRING Function
• 27.134 UNEXPIRE_END_USER_ACCOUNT Procedure
• 27.135 UNEXPIRE_WORKSPACE_ACCOUNT Procedure
• 27.136 UNLOCK_ACCOUNT Procedure
• 27.137 URL_ENCODE Function
• 27.138 WORKSPACE_ACCOUNT_DAYS_LEFT Function

28 APEX_WEB_SERVICE

• 28.1 About the APEX_WEB_SERVICE API
• 28.2 Invoking a SOAP Style Web Service
• 28.3 Invoking a RESTful Style Web Service
• 28.4 Retrieving Cookies and HTTP Headers
• 28.5 Setting Cookies and HTTP Headers
• 28.6 BLOB2CLOBBASE64 Function
• 28.7 CLOBBASE642BLOB Function
• 28.8 MAKE_REQUEST Procedure
• 28.9 MAKE_REQUEST Function
• 28.10 MAKE_REST_REQUEST Function
• 28.11 MAKE_REST_REQUEST_B Function
• 28.12 PARSE_RESPONSE Function
• 28.13 PARSE_RESPONSE_CLOB Function
• 28.14 PARSE_XML Function
• 28.15 PARSE_XML_CLOB Function

29 APEX_ZIP

• 29.1 Data Types
• 29.2 ADD_FILE Procedure
• 29.3 FINISH Procedure
• 29.4 GET_FILE_CONTENT Function
• 29.5 GET_FILES Function

30 JavaScript APIs

• 30.1 apex namespace
  • 30.1.1 About apex.confirm Function
  • 30.1.2 apex.confirm Signature 1
  • 30.1.3 apex.confirm Signature 2
  • 30.1.4 apex.gPageContext$ Property
  • 30.1.5 apex.jQuery Property
  • 30.1.6 About apex.submit Function
  • 30.1.7 apex.submit Signature 1
  • 30.1.8 apex.submit Signature 2
• 30.2 apex.da namespace
  • 30.2.1 apex.da.resume
• 30.3 apex.debug namespace
  • 30.3.1 Log Level Constants
  • 30.3.2 apex.debug.error
  • 30.3.3 apex.debug.getLevel
  • 30.3.4 apex.debug.info
  • 30.3.5 apex.debug.log
  • 30.3.6 apex.debug.message
  • 30.3.7 apex.debug.setLevel
  • 30.3.8 apex.debug.trace
  • 30.3.9 apex.debug.warn
• 30.4 apex.event namespace
  • 30.4.1 apex.event.trigger
• 30.5 apex.item
  • 30.5.1 pNd
  • 30.5.2 addValue
  • 30.5.3 disable
  • 30.5.4 displayValueFor
  • 30.5.5 enable
  • 30.5.6 getPopupSelector
  • 30.5.7 getValidity
  • 30.5.8 getValidationMessage
  • 30.5.9 getValue
  • 30.5.10 hide
  • 30.5.11 isChanged
  • 30.5.12 isEmpty
  • 30.5.13 setFocus
  • 30.5.14 setStyle
  • 30.5.15 setValue
  • 30.5.16 show
  • 30.5.17 create
• 30.6 apex.lang namespace
  • 30.6.1 apex.lang.addMessages
  • 30.6.2 apex.lang.clearMessages
  • 30.6.3 apex.lang.format
  • 30.6.4 apex.lang.formatMessage
  • 30.6.5 apex.lang.formatMessageNoEscape
  • 30.6.6 apex.lang.formatNoEscape
  • 30.6.7 apex.lang.getMessage
• 30.7 apex.navigation namespace
  • 30.7.1 apex.navigation.dialog
  • 30.7.2 apex.navigation.dialog.cancel
  • 30.7.3 apex.navigation.dialog.close
  • 30.7.4 apex.navigation.dialog.fireCloseHandler
  • 30.7.5 apex.navigation.dialog.registerCloseHandler
  • 30.7.6 apex.navigation.openInNewWindow
  • 30.7.7 apex.navigation.popup
  • 30.7.8 apex.navigation.popup.close
  • 30.7.9 apex.navigation.redirect
• 30.8 apex.page namespace
  • 30.8.1 apex.page.cancelWarnOnUnsavedChanges
  • 30.8.2 apex.page.confirm Signature 1
  • 30.8.3 apex.page.confirm Signature 2
  • 30.8.4 apex.page.submit Signature 1
  • 30.8.5 apex.page.submit Signature 2
  • 30.8.6 apex.page.validate
  • 30.8.7 apex.page.isChanged
  • 30.8.8 apex.page.warnOnUnsavedChanges
• 30.9 apex.region
  • 30.9.1 pRegionId
    • 30.9.1.1 focus
    • 30.9.1.2 refresh
    • 30.9.1.3 widget
  • 30.9.2 apex.region.create
  • 30.9.3 apex.region.destroy
  • 30.9.4 apex.region.isRegion
  • 30.9.5 apex.region.findClosest
• 30.10 apex.server namespace
  • 30.10.1 apex.server.plugin
  • 30.10.2 apex.server.pluginUrl
  • 30.10.3 apex.server.process
  • 30.10.4 apex.server.url
• 30.11 apex.storage namespace
  • 30.11.1 About local and session storage
  • 30.11.2 apex.storage.getCookie
  • 30.11.3 apex.storage.hasLocalStorageSupport
  • 30.11.4 apex.storage.getScopedLocalStorage
  • 30.11.5 apex.storage.getScopedSessionStorage
  • 30.11.6 apex.storage.hasSessionStorageSupport
  • 30.11.7 apex.storage.setCookie
• 30.12 apex.util namespace
  • 30.12.1 apex.util.escapeCSS
  • 30.12.2 apex.util.escapeHTML
  • 30.12.3 apex.util.showSpinner
  • 30.12.4 apex.util.stripHTML
  • 30.12.5 apex.util.applyTemplate
  • 30.12.6 About apex.util.delayLinger
  • 30.12.7 apex.util.delayLinger.start
  • 30.12.8 apex.util.delayLinger.finish
• 30.13 apex.widget namespace
  • 30.13.1 apex.widget.initPageItem
• 30.14 Events
  • 30.14.1 apexafterclosedialog
  • 30.14.2 apexafterrefresh
  • 30.14.3 apexbeforerefresh
  • 30.14.4 apexbeforepagesubmit
  • 30.14.5 apexbeginrecordedit
  • 30.14.6 apexendrecordedit
  • 30.14.7 apexpagesubmit
  • 30.14.8 apexwindowresized
• 30.15 Non-namespace JavaScript APIs
  • 30.15.1 $x
  • 30.15.2 $v
  • 30.15.3 $v2
  • 30.15.4 $s
  • 30.15.5 $u_Narray
  • 30.15.6 $u_Carray
  • 30.15.7 $nvl
  • 30.15.8 $x_Style
  • 30.15.9 $x_Hide
  • 30.15.10 $x_Show
  • 30.15.11 $x_Toggle
  • 30.15.12 $x_Remove
  • 30.15.13 $x_Value
  • 30.15.14 $x_UpTill
  • 30.15.15 $x_ItemRow
  • 30.15.16 $x_HideItemRow
  • 30.15.17 $x_ShowItemRow
  • 30.15.18 $x_ToggleItemRow
  • 30.15.19 $x_HideAllExcept
  • 30.15.20 $x_HideSiblings
  • 30.15.21 $x_ShowSiblings
  • 30.15.22 $x_Class
  • 30.15.23 $x_SetSiblingsClass
  • 30.15.24 $x_ByClass
  • 30.15.25 $x_ShowAllByClass
  • 30.15.26 $x_ShowChildren
  • 30.15.27 $x_HideChildren
  • 30.15.28 $x_disableItem
  • 30.15.29 $f_get_emptys
  • 30.15.30 $v_Array
  • 30.15.31 $f_ReturnChecked
  • 30.15.32 $d_ClearAndHide
  • 30.15.33 $f_SelectedOptions
  • 30.15.34 $f_SelectValue
  • 30.15.35 $u_ArrayToString
  • 30.15.36 $x_CheckImageSrc
  • 30.15.37 $v_CheckValueAgainst
  • 30.15.38 $f_Hide_On_Value_Item
  • 30.15.39 $f_Show_On_Value_Item
  • 30.15.40 $f_Hide_On_Value_Item_Row
  • 30.15.41 $f_Show_On_Value_Item_Row
  • 30.15.42 $f_DisableOnValue
  • 30.15.43 $x_ClassByClass
  • 30.15.44 $f_ValuesToArray
  • 30.15.45 $x_FormItems
  • 30.15.46 $f_CheckAll
  • 30.15.47 $f_CheckFirstColumn
  • 30.15.48 $x_ToggleWithImage
  • 30.15.49 $x_SwitchImageSrc
  • 30.15.50 $x_CheckImageSrc
  • 30.15.51 $u_SubString
  • 30.15.52 html_RemoveAllChildren
  • 30.15.53 html_SetSelectValue
  • 30.15.54 addLoadEvent
  • 30.15.55 $f_Swap
  • 30.15.56 $f_SetValueSequence
  • 30.15.57 $dom_AddTag
  • 30.15.58 $tr_AddTD
  • 30.15.59 $tr_AddTH
  • 30.15.60 $dom_AddInput
  • 30.15.61 $dom_MakeParent
  • 30.15.62 $x_RowHighlight
  • 30.15.63 $x_RowHighlightOff
  • 30.15.64 $v_Upper
  • 30.15.65 $d_Find
  • 30.15.66 $f_First_field
• 30.16 Legacy JavaScript APIs
  • 30.16.1 $v_PopupReturn [Deprecated]
  • 30.16.2 $v_IsEmpty [Deprecated]
  • 30.16.3 submitEnter [Deprecated]
  • 30.16.4 setReturn [Deprecated]
  • 30.16.5 GetCookie [Deprecated]
  • 30.16.6 SetCookie [Deprecated]

Index