Go to main content
1/647
Contents
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_KEEP_SESSIONS Function
2.13
GET_OFFSET Function
2.14
GET_PROXY Function
2.15
GET_SCHEMA Function
2.16
GET_WORKSPACE_ID Function
2.17
SET_APPLICATION_ALIAS Procedure
2.18
SET_APPLICATION_ID Procedure
2.19
SET_APPLICATION_NAME Procedure
2.20
SET_AUTO_INSTALL_SUP_OBJ Procedure
2.21
SET_IMAGE_PREFIX Procedure
2.22
SET_KEEP_SESSIONS Procedure
2.23
SET_OFFSET Procedure
2.24
SET_PROXY Procedure
2.25
SET_SCHEMA Procedure
2.26
SET_WORKSPACE_ID Procedure
2.27
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_COLLECTION
5.1
About the APEX_COLLECTION API
5.2
Naming Collections
5.3
Creating a Collection
5.4
About the Parameter p_generate_md5
5.5
Accessing a Collection
5.6
Merging Collections
5.7
Truncating a Collection
5.8
Deleting a Collection
5.9
Deleting All Collections for the Current Application
5.10
Deleting All Collections in the Current Session
5.11
Adding Members to a Collection
5.12
About the Parameters p_generate_md5, p_clob001, p_blob001, and p_xmltype001
5.13
Updating Collection Members
5.14
Deleting Collection Members
5.15
Obtaining a Member Count
5.16
Resequencing a Collection
5.17
Verifying Whether a Collection Exists
5.18
Adjusting a Member Sequence ID
5.19
Sorting Collection Members
5.20
Clearing Collection Session State
5.21
Determining Collection Status
5.22
ADD_MEMBER Procedure
5.23
ADD_MEMBER Function
5.24
ADD_MEMBERS Procedure
5.25
COLLECTION_EXISTS Function
5.26
COLLECTION_HAS_CHANGED Function
5.27
COLLECTION_MEMBER_COUNT Function
5.28
CREATE_COLLECTION Procedure
5.29
CREATE_OR_TRUNCATE_COLLECTION Procedure
5.30
CREATE_COLLECTION_FROM_QUERY Procedure
5.31
CREATE_COLLECTION_FROM_QUERY2 Procedure
5.32
CREATE_COLLECTION_FROM_QUERY_B Procedure
5.33
CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
5.34
CREATE_COLLECTION_FROM_QUERYB2 Procedure
5.35
CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
5.36
DELETE_ALL_COLLECTIONS Procedure
5.37
DELETE_ALL_COLLECTIONS_SESSION Procedure
5.38
DELETE_COLLECTION Procedure
5.39
DELETE_MEMBER Procedure
5.40
DELETE_MEMBERS Procedure
5.41
GET_MEMBER_MD5 Function
5.42
MERGE_MEMBERS Procedure
5.43
MOVE_MEMBER_DOWN Procedure
5.44
MOVE_MEMBER_UP Procedure
5.45
RESEQUENCE_COLLECTION Procedure
5.46
RESET_COLLECTION_CHANGED Procedure
5.47
RESET_COLLECTION_CHANGED_ALL Procedure
5.48
SORT_MEMBERS Procedure
5.49
TRUNCATE_COLLECTION Procedure
5.50
UPDATE_MEMBER Procedure
5.51
UPDATE_MEMBERS Procedure
5.52
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
5.53
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
5.54
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
5.55
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
5.56
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
5.57
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6
6
APEX_CSS
6.1
ADD Procedure
6.2
ADD_3RD_PARTY_LIBRARY_FILE Procedure
6.3
ADD_FILE Procedure
7
APEX_CUSTOM_AUTH
7.1
APPLICATION_PAGE_ITEM_EXISTS Function
7.2
CURRENT_PAGE_IS_PUBLIC Function
7.3
DEFINE_USER_SESSION Procedure
7.4
GET_COOKIE_PROPS Procedure
7.5
GET_LDAP_PROPS Procedure
7.6
GET_NEXT_SESSION_ID Function
7.7
GET_SECURITY_GROUP_ID Function
7.8
GET_SESSION_ID Function
7.9
GET_SESSION_ID_FROM_COOKIE Function
7.10
GET_USER Function
7.11
GET_USERNAME Function
7.12
IS_SESSION_VALID Function
7.13
LOGIN Procedure
7.14
LOGOUT Procedure [DEPRECATED]
7.15
POST_LOGIN Procedure
7.16
SESSION_ID_EXISTS Function
7.17
SET_SESSION_ID Procedure
7.18
SET_SESSION_ID_TO_NEXT_VALUE Procedure
7.19
SET_USER Procedure
8
APEX_DEBUG
8.1
Constants
8.2
DISABLE Procedure
8.3
DISABLE_DBMS_OUTPUT Procedure
8.4
ENABLE Procedure
8.5
ENTER Procedure
8.6
ENABLE_DBMS_OUTPUT Procedure
8.7
ERROR Procedure
8.8
INFO Procedure
8.9
LOG_DBMS_OUTPUT Procedure
8.10
LOG_LONG_MESSAGE Procedure
8.11
LOG_MESSAGE Procedure [Deprecated]
8.12
LOG_PAGE_SESSION_STATE Procedure
8.13
MESSAGE Procedure
8.14
REMOVE_DEBUG_BY_AGE Procedure
8.15
REMOVE_DEBUG_BY_APP Procedure
8.16
REMOVE_DEBUG_BY_VIEW Procedure
8.17
REMOVE_SESSION_MESSAGES Procedure
8.18
TOCHAR Function
8.19
TRACE Procedure
8.20
WARN Procedure
9
APEX_ESCAPE
9.1
Constants
9.2
HTML Function
9.3
HTML_ATTRIBUTE Function
9.4
HTML_TRUNC Function
9.5
HTML_WHITELIST Function
9.6
JS_LITERAL Function
9.7
JSON Function
9.8
LDAP_DN Function
9.9
LDAP_SEARCH_FILTER Function
9.10
NOOP Function
9.11
REGEXP Function
9.12
SET_HTML_ESCAPING_MODE 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_INSTANCE_ADMIN
11.1
Available Parameter Values
11.2
ADD_SCHEMA Procedure
11.3
ADD_WORKSPACE Procedure
11.4
CREATE_SCHEMA_EXCEPTION Procedure
11.5
FREE_WORKSPACE_APP_IDS Procedure
11.6
GET_PARAMETER Function
11.7
GET_SCHEMAS Function
11.8
GET_WORKSPACE_PARAMETER
11.9
REMOVE_APPLICATION Procedure
11.10
REMOVE_SAVED_REPORT Procedure
11.11
REMOVE_SAVED_REPORTS Procedure
11.12
REMOVE_SCHEMA Procedure
11.13
REMOVE_SCHEMA_EXCEPTION Procedure
11.14
REMOVE_SCHEMA_EXCEPTIONS Procedure
11.15
REMOVE_SUBSCRIPTION Procedure
11.16
REMOVE_WORKSPACE Procedure
11.17
REMOVE_WORKSPACE_EXCEPTIONS Procedure
11.18
RESERVE_WORKSPACE_APP_IDS Procedure
11.19
RESTRICT_SCHEMA Procedure
11.20
SET_LOG_SWITCH_INTERVAL Procedure
11.21
SET_WORKSPACE_PARAMETER
11.22
SET_PARAMETER Procedure
11.23
SET_WORKSPACE_CONSUMER_GROUP Procedure
11.24
TRUNCATE_LOG Procedure
11.25
UNRESTRICT_SCHEMA Procedure
12
APEX_IR
12.1
ADD_FILTER Procedure Signature 1
12.2
ADD_FILTER Procedure Signature 2
12.3
CHANGE_SUBSCRIPTION_EMAIL Procedure
12.4
CHANGE_REPORT_OWNER Procedure
12.5
CHANGE_SUBSCRIPTION_EMAIL Procedure
12.6
CHANGE_SUBSCRIPTION_LANG Procedure
12.7
CLEAR_REPORT Procedure Signature 1
12.8
CLEAR_REPORT Procedure Signature 2
12.9
DELETE_REPORT Procedure
12.10
DELETE_SUBSCRIPTION Procedure
12.11
GET_LAST_VIEWED_REPORT_ID Function
12.12
GET_REPORT Function
12.13
RESET_REPORT Procedure Signature 1
12.14
RESET_REPORT Procedure Signature 2
13
APEX_ITEM
13.1
CHECKBOX2 Function
13.2
DATE_POPUP Function
13.3
DATE_POPUP2 Function
13.4
DISPLAY_AND_SAVE Function
13.5
HIDDEN Function
13.6
MD5_CHECKSUM Function
13.7
MD5_HIDDEN Function
13.8
POPUP_FROM_LOV Function
13.9
POPUP_FROM_QUERY Function
13.10
POPUPKEY_FROM_LOV Function
13.11
POPUPKEY_FROM_QUERY Function
13.12
RADIOGROUP Function
13.13
SELECT_LIST Function
13.14
SELECT_LIST_FROM_LOV Function
13.15
SELECT_LIST_FROM_LOV_XL Function
13.16
SELECT_LIST_FROM_QUERY Function
13.17
SELECT_LIST_FROM_QUERY_XL Function
13.18
SWITCH Function
13.19
TEXT Function
13.20
TEXTAREA Function
13.21
TEXT_FROM_LOV Function
13.22
TEXT_FROM_LOV_QUERY Function
14
APEX_JAVASCRIPT
14.1
ADD_3RD_PARTY_LIBRARY_FILE Procedure
14.2
ADD_ATTRIBUTE Function Signature 1
14.3
ADD_ATTRIBUTE Function Signature 2
14.4
ADD_ATTRIBUTE Function Signature 3
14.5
ADD_ATTRIBUTE Function Signature 4
14.6
ADD_INLINE_CODE Procedure
14.7
ADD_LIBRARY Procedure
14.8
ADD_REQUIREJS Procedure
14.9
ADD_REQUIREJS_DEFINE Procedure
14.10
ADD_ONLOAD_CODE Procedure
14.11
ADD_VALUE Function Signature 1
14.12
ADD_VALUE Function Signature 2
14.13
ADD_VALUE Function Signature 3
14.14
ADD_VALUE Function Signature 4
14.15
Escape Function
15
APEX_JSON
15.1
Package Overview and Examples
15.2
Constants and Data Types
15.3
CLOSE_ALL Procedure
15.4
CLOSE_ARRAY Procedure
15.5
CLOSE_OBJECT Procedure
15.6
DOES_EXIST Function
15.7
FIND_PATHS_LIKE Function
15.8
FREE_OUTPUT Procedure
15.9
FLUSH Procedure
15.10
GET_BOOLEAN Function
15.11
GET_CLOB_OUTPUT Function
15.12
GET_COUNT Function
15.13
GET_DATE Function
15.14
GET_MEMBERS Function
15.15
GET_NUMBER Function
15.16
GET_VALUE Function
15.17
GET_VARCHAR2 Function
15.18
GET_CLOB Function
15.19
INITIALIZE_CLOB_OUTPUT Procedure
15.20
INITIALIZE_OUTPUT Procedure
15.21
OPEN_ARRAY Procedure
15.22
OPEN_OBJECT Procedure
15.23
PARSE Procedure Signature 1
15.24
PARSE Procedure Signature 2
15.25
STRINGIFY Function Signature 1
15.26
STRINGIFY Function Signature 2
15.27
STRINGIFY Function Signature 3
15.28
STRINGIFY Function Signature 4
15.29
TO_XMLTYPE Function
15.30
WRITE Procedure Signature 1
15.31
WRITE Procedure Signature 2
15.32
WRITE Procedure Signature 3
15.33
WRITE Procedure Signature 4
15.34
WRITE Procedure Signature 5
15.35
WRITE Procedure Signature 6
15.36
WRITE Procedure Signature 7
15.37
WRITE Procedure Signature 8
15.38
WRITE Procedure Signature 9
15.39
WRITE Procedure Signature 10
15.40
WRITE Procedure Signature 11
15.41
WRITE Procedure Signature 12
15.42
WRITE Procedure Signature 13
15.43
WRITE Procedure Signature 14
15.44
WRITE Procedure Signature 15
15.45
WRITE Procedure Signature 16
15.46
WRITE Procedure Signature 17
15.47
WRITE Procedure Signature 18
16
APEX_LANG
16.1
CREATE_LANGUAGE_MAPPING Procedure
16.2
DELETE_LANGUAGE_MAPPING Procedure
16.3
LANG Function
16.4
MESSAGE Function
16.5
PUBLISH_APPLICATION Procedure
16.6
SEED_TRANSLATIONS Procedure
16.7
UPDATE_LANGUAGE_MAPPING Procedure
16.8
UPDATE_MESSAGE Procedure
16.9
UPDATE_TRANSLATED_STRING Procedure
17
APEX_LDAP
17.1
AUTHENTICATE Function
17.2
GET_ALL_USER_ATTRIBUTES Procedure
17.3
GET_USER_ATTRIBUTES Procedure
17.4
IS_MEMBER Function
17.5
MEMBER_OF Function
17.6
MEMBER_OF2 Function
17.7
SEARCH Function
18
APEX_MAIL
18.1
Configuring Oracle Application Express to Send Email
18.2
ADD_ATTACHMENT Procedure
18.3
GET_IMAGES_URL Function
18.4
GET_INSTANCE_URL Function
18.5
PUSH_QUEUE Procedure
18.6
SEND Procedure
18.7
SEND Function
19
APEX_PAGE
19.1
Global Constants
19.2
IS_DESKTOP_UI Function
19.3
IS_JQM_SMARTPHONE_UI Function
19.4
IS_JQM_TABLET_UI Function
19.5
GET_UI_TYPE Function
19.6
IS_READ_ONLY Function
19.7
GET_PAGE_MODE Function
19.8
PURGE_CACHE Procedure
19.9
GET_URL Function
20
APEX_PLUGIN
20.1
Data Types
20.2
GET_AJAX_IDENTIFIER Function
20.3
GET_INPUT_NAME_FOR_PAGE_ITEM Function
21
APEX_PLUGIN_UTIL
21.1
CLEAR_COMPONENT_VALUES Procedure
21.2
DEBUG_DYNAMIC _ACTION Procedure
21.3
DEBUG_PAGE_ITEM Procedure Signature 1
21.4
DEBUG_PAGE_ITEM Procedure Signature 2
21.5
DEBUG_PROCESS Procedure
21.6
DEBUG_REGION Procedure Signature 1
21.7
DEBUG_REGION Procedure Signature 2
21.8
ESCAPE Function
21.9
EXECUTE_PLSQL_CODE Procedure
21.10
GET_ATTRIBUTE_AS_NUMBER Function
21.11
GET_DATA Function Signature 1
21.12
GET_DATA Function Signature 2
21.13
GET_DATA2 Function Signature 1
21.14
GET_DATA2 Function Signature 2
21.15
GET_DISPLAY_DATA Function Signature 1
21.16
GET_DISPLAY_DATA Function Signature 2
21.17
GET_ELEMENT_ATTRIBUTES Function
21.18
GET_PLSQL_EXPRESSION_RESULT Function
21.19
GET_PLSQL_FUNCTION_RESULT Function
21.20
GET_POSITION_IN_LIST Function
21.21
GET_SEARCH_STRING Function
21.22
GET_VALUE_AS_VARCHAR2 Function
21.23
IS_EQUAL Function
21.24
PAGE_ITEM_NAMES_TO_JQUERY Function
21.25
PRINT_DISPLAY_ONLY Procedure
21.26
PRINT_ESCAPED_VALUE Procedure
21.27
PRINT_HIDDEN_IF_READONLY Procedure
21.28
PRINT_JSON_HTTP_HEADER Procedure
21.29
PRINT_LOV_AS_JSON Procedure
21.30
PRINT_OPTION Procedure
21.31
REPLACE_SUBSTITUTIONS Function
21.32
SET_COMPONENT_VALUES Procedure
22
APEX_REGION
22.1
IS_READ_ONLY Function
22.2
PURGE_CACHE Procedure
23
APEX_SESSION
23.1
SET_DEBUG Procedure
23.2
SET_TRACE 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_STRING
25.1
FORMAT Function
25.2
GET_INITIALS Function
25.3
GREP Function Signature 1
25.4
GREP Function Signature 2
25.5
GREP Function Signature 3
25.6
JOIN_CLOB Function
25.7
JOIN Function Signature 1
25.8
JOIN Function Signature 2
25.9
PLIST_DELETE Procedure
25.10
PLIST_GET Function
25.11
PLIST_PUT Function
25.12
PUSH Procedure Signature 1
25.13
PUSH Procedure Signature 2
25.14
PUSH Procedure Signature 3
25.15
SHUFFLE Function
25.16
SHUFFLE Procedure
25.17
SPLIT Function Signature 1
25.18
SPLIT Function Signature 2
25.19
SPLIT_NUMBERS Function
26
APEX_THEME
26.1
CLEAR_ALL_USERS_STYLE Procedure
26.2
CLEAR_USER_STYLE Procedure
26.3
DISABLE_USER_STYLE Procedure
26.4
ENABLE_USER_STYLE Procedure
26.5
GET_USER_STYLE Function
26.6
SET_CURRENT_STYLE Procedure
26.7
SET_SESSION_STYLE Procedure
26.8
SET_SESSION_STYLE_CSS Procedure
26.9
SET_USER_STYLE Procedure
27
APEX_UI_DEFAULT_UPDATE
27.1
ADD_AD_COLUMN Procedure
27.2
ADD_AD_SYNONYM Procedure
27.3
DEL_AD_COLUMN Procedure
27.4
DEL_AD_SYNONYM Procedure
27.5
DEL_COLUMN Procedure
27.6
DEL_GROUP Procedure
27.7
DEL_TABLE Procedure
27.8
SYNCH_TABLE Procedure
27.9
UPD_AD_COLUMN Procedure
27.10
UPD_AD_SYNONYM Procedure
27.11
UPD_COLUMN Procedure
27.12
UPD_DISPLAY_IN_FORM Procedure
27.13
UPD_DISPLAY_IN_REPORT Procedure
27.14
UPD_FORM_REGION_TITLE Procedure
27.15
UPD_GROUP Procedure
27.16
UPD_ITEM_DISPLAY_HEIGHT Procedure
27.17
UPD_ITEM_DISPLAY_WIDTH Procedure
27.18
UPD_ITEM_FORMAT_MASK Procedure
27.19
UPD_ITEM_HELP Procedure
27.20
UPD_LABEL Procedure
27.21
UPD_REPORT_ALIGNMENT Procedure
27.22
UPD_REPORT_FORMAT_MASK Procedure
27.23
UPD_REPORT_REGION_TITLE Procedure
27.24
UPD_TABLE Procedure
28
APEX_UTIL
28.1
CACHE_GET_DATE_OF_PAGE_CACHE Function
28.2
CACHE_GET_DATE_OF_REGION_CACHE Function
28.3
CACHE_PURGE_BY_APPLICATION Procedure
28.4
CACHE_PURGE_BY_PAGE Procedure
28.5
CACHE_PURGE_STALE Procedure
28.6
CHANGE_CURRENT_USER_PW Procedure
28.7
CHANGE_PASSWORD_ON_FIRST_USE Function
28.8
CLOSE_OPEN_DB_LINKS Procedure
28.9
CLEAR_APP_CACHE Procedure
28.10
CLEAR_PAGE_CACHE Procedure
28.11
CLEAR_USER_CACHE Procedure
28.12
COUNT_CLICK Procedure
28.13
CREATE_USER Procedure
28.14
CREATE_USER_GROUP Procedure
28.15
CURRENT_USER_IN_GROUP Function
28.16
CUSTOM_CALENDAR Procedure
28.17
DELETE_USER_GROUP Procedure Signature 1
28.18
DELETE_USER_GROUP Procedure Signature 2
28.19
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
28.20
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
28.21
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
28.22
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
28.23
EDIT_USER Procedure
28.24
END_USER_ACCOUNT_DAYS_LEFT Function
28.25
EXPIRE_END_USER_ACCOUNT Procedure
28.26
EXPIRE_WORKSPACE_ACCOUNT Procedure
28.27
EXPORT_USERS Procedure
28.28
FETCH_APP_ITEM Function
28.29
FETCH_USER Procedure Signature 1
28.30
FETCH_USER Procedure Signature 2
28.31
FETCH_USER Procedure Signature 3
28.32
FIND_SECURITY_GROUP_ID Function
28.33
FIND_WORKSPACE Function
28.34
GET_ACCOUNT_LOCKED_STATUS Function
28.35
GET_APPLICATION_STATUS Function
28.36
GET_ATTRIBUTE Function
28.37
GET_AUTHENTICATION_RESULT Function
28.38
GET_BLOB_FILE_SRC Function
28.39
GET_BUILD_OPTION_STATUS Function Signature 1
28.40
GET_BUILD_OPTION_STATUS Function Signature 2
28.41
GET_CURRENT_USER_ID Function
28.42
GET_DEFAULT_SCHEMA Function
28.43
GET_EDITION Function
28.44
GET_EMAIL Function
28.45
GET_FEEDBACK_FOLLOW_UP Function
28.46
GET_FILE Procedure
28.47
GET_FILE_ID Function
28.48
GET_FIRST_NAME Function
28.49
GET_GLOBAL_NOTIFICATION Function
28.50
GET_GROUPS_USER_BELONGS_TO Function
28.51
GET_GROUP_ID Function
28.52
GET_GROUP_NAME Function
28.53
GET_HASH Function
28.54
GET_HIGH_CONTRAST_MODE_TOGGLE Function
28.55
GET_LAST_NAME Function
28.56
GET_NUMERIC_SESSION_STATE Function
28.57
GET_PREFERENCE Function
28.58
GET_PRINT_DOCUMENT Function Signature 1
28.59
GET_PRINT_DOCUMENT Function Signature 2
28.60
GET_PRINT_DOCUMENT Function Signature 3
28.61
GET_PRINT_DOCUMENT Function Signature 4
28.62
GET_SCREEN_READER_MODE_TOGGLE Function
28.63
GET_SESSION_LANG Function
28.64
GET_SESSION_STATE Function
28.65
GET_SESSION_TERRITORY Function
28.66
GET_SESSION_TIME_ZONE Function
28.67
GET_SINCE Function
28.68
GET_SUPPORTING_OBJECT_SCRIPT Function
28.69
GET_SUPPORTING_OBJECT_SCRIPT Procedure
28.70
GET_USER_ID Function
28.71
GET_USER_ROLES Function
28.72
GET_USERNAME Function
28.73
HOST_URL Function
28.74
HTML_PCT_GRAPH_MASK Function
28.75
INCREMENT_CALENDAR Procedure
28.76
IR_CLEAR Procedure [DEPRECATED]
28.77
IR_DELETE_REPORT Procedure [DEPRECATED]
28.78
IR_DELETE_SUBSCRIPTION Procedure [DEPRECATED]
28.79
IR_FILTER Procedure [DEPRECATED]
28.80
IR_RESET Procedure [DEPRECATED]
28.81
IS_HIGH_CONTRAST_SESSION Function
28.82
IS_HIGH_CONTRAST_SESSION_YN Function
28.83
IS_LOGIN_PASSWORD_VALID Function
28.84
IS_SCREEN_READER_SESSION Function
28.85
IS_SCREEN_READER_SESSION_YN Function
28.86
IS_USERNAME_UNIQUE Function
28.87
KEYVAL_NUM Function
28.88
KEYVAL_VC2 Function
28.89
LOCK_ACCOUNT Procedure
28.90
PASSWORD_FIRST_USE_OCCURRED Function
28.91
PREPARE_URL Function
28.92
PUBLIC_CHECK_AUTHORIZATION Function [DEPRECATED]
28.93
PURGE_REGIONS_BY_APP Procedure
28.94
PURGE_REGIONS_BY_NAME Procedure
28.95
PURGE_REGIONS_BY_PAGE Procedure
28.96
REDIRECT_URL Procedure
28.97
REMOVE_PREFERENCE Procedure
28.98
REMOVE_SORT_PREFERENCES Procedure
28.99
REMOVE_USER Procedure
28.100
RESET_AUTHORIZATIONS Procedure [DEPRECATED]
28.101
RESET_PASSWORD Procedure
28.102
RESET_PW Procedure
28.103
SAVEKEY_NUM Function
28.104
SAVEKEY_VC2 Function
28.105
SET_APP_BUILD_STATUS Procedure
28.106
SET_APPLICATION_STATUS Procedure
28.107
SET_ATTRIBUTE Procedure
28.108
SET_AUTHENTICATION_RESULT Procedure
28.109
SET_BUILD_OPTION_STATUS Procedure
28.110
SET_CURRENT_THEME_STYLE Procedure [DEPRECATED]
28.111
SET_CUSTOM_AUTH_STATUS Procedure
28.112
SET_EDITION Procedure
28.113
SET_EMAIL Procedure
28.114
SET_FIRST_NAME Procedure
28.115
SET_GLOBAL_NOTIFICATION Procedure
28.116
SET_GROUP_GROUP_GRANTS Procedure
28.117
SET_GROUP_USER_GRANTS Procedure
28.118
SET_LAST_NAME Procedure
28.119
SET_PREFERENCE Procedure
28.120
SET_SECURITY_GROUP_ID Procedure
28.121
SET_SESSION_HIGH_CONTRAST_OFF Procedure
28.122
SET_SESSION_HIGH_CONTRAST_ON Procedure
28.123
SET_SESSION_LANG Procedure
28.124
SET_SESSION_LIFETIME_SECONDS Procedure
28.125
SET_SESSION_MAX_IDLE_SECONDS Procedure
28.126
SET_SESSION_SCREEN_READER_OFF Procedure
28.127
SET_SESSION_SCREEN_READER_ON Procedure
28.128
SET_SESSION_STATE Procedure
28.129
SET_SESSION_TERRITORY Procedure
28.130
SET_SESSION_TIME_ZONE Procedure
28.131
SET_USERNAME Procedure
28.132
SET_WORKSPACE_Procedure
28.133
SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
28.134
SHOW_SCREEN_READER_MODE_TOGGLE Procedure
28.135
STRING_TO_TABLE Function [DEPRECATED]
28.136
STRONG_PASSWORD_CHECK Procedure
28.137
STRONG_PASSWORD_VALIDATION Function
28.138
SUBMIT_FEEDBACK Procedure
28.139
SUBMIT_FEEDBACK_FOLLOWUP Procedure
28.140
TABLE_TO_STRING Function [DEPRECATED]
28.141
UNEXPIRE_END_USER_ACCOUNT Procedure
28.142
UNEXPIRE_WORKSPACE_ACCOUNT Procedure
28.143
UNLOCK_ACCOUNT Procedure
28.144
URL_ENCODE Function
28.145
WORKSPACE_ACCOUNT_DAYS_LEFT Function
29
APEX_WEB_SERVICE
29.1
About the APEX_WEB_SERVICE API
29.2
Invoking a SOAP Style Web Service
29.3
Invoking a RESTful Style Web Service
29.4
Retrieving Cookies and HTTP Headers
29.5
Setting Cookies and HTTP Headers
29.6
BLOB2CLOBBASE64 Function
29.7
CLOBBASE642BLOB Function
29.8
MAKE_REQUEST Procedure
29.9
MAKE_REQUEST Function
29.10
MAKE_REST_REQUEST Function
29.11
MAKE_REST_REQUEST_B Function
29.12
OAUTH_AUTHENTICATE Function
29.13
OAUTH_GET_LAST_TOKEN Function
29.14
OAUTH_SET_TOKEN Function
29.15
PARSE_RESPONSE Function
29.16
PARSE_RESPONSE_CLOB Function
29.17
PARSE_XML Function
29.18
PARSE_XML_CLOB Function
30
APEX_ZIP
30.1
Data Types
30.2
ADD_FILE Procedure
30.3
FINISH Procedure
30.4
GET_FILE_CONTENT Function
30.5
GET_FILES Function
31
JavaScript APIs
31.1
apex namespace
31.1.1
About apex.confirm Function
31.1.2
apex.confirm Signature 1
31.1.3
apex.confirm Signature 2
31.1.4
apex.gPageContext$ Property
31.1.5
apex.jQuery Property
31.1.6
About apex.submit Function
31.1.7
apex.submit Signature 1
31.1.8
apex.submit Signature 2
31.2
apex.da namespace
31.2.1
apex.da.resume
31.3
apex.debug namespace
31.3.1
Log Level Constants
31.3.2
apex.debug.error
31.3.3
apex.debug.getLevel
31.3.4
apex.debug.info
31.3.5
apex.debug.log
31.3.6
apex.debug.message
31.3.7
apex.debug.setLevel
31.3.8
apex.debug.trace
31.3.9
apex.debug.warn
31.4
apex.event namespace
31.4.1
apex.event.trigger
31.5
apex.item
31.5.1
apex.item
31.5.2
addValue
31.5.3
disable
31.5.4
displayValueFor
31.5.5
enable
31.5.6
getValidity
31.5.7
getValidationMessage
31.5.8
getValue
31.5.9
hide
31.5.10
isChanged
31.5.11
isDisabled
31.5.12
isEmpty
31.5.13
Item Object Properties
31.5.14
setFocus
31.5.15
setStyle
31.5.16
setValue
31.5.17
show
31.5.18
apex.item.create
31.6
apex.lang namespace
31.6.1
apex.lang.addMessages
31.6.2
apex.lang.clearMessages
31.6.3
apex.lang.format
31.6.4
apex.lang.formatMessage
31.6.5
apex.lang.formatMessageNoEscape
31.6.6
apex.lang.formatNoEscape
31.6.7
apex.lang.getMessage
31.7
apex.message namespace
31.7.1
apex.message.addVisibilityCheck
31.7.2
apex.message.alert
31.7.3
apex.message.clearErrors
31.7.4
apex.message.confirm
31.7.5
apex.message.hidePageSuccess
31.7.6
apex.message.setThemeHooks
31.7.7
apex.message.showErrors
31.7.8
apex.message.showPageSuccess
31.7.9
apex.message.TYPE
31.8
apex.navigation namespace
31.8.1
apex.navigation.dialog
31.8.2
apex.navigation.dialog.cancel
31.8.3
apex.navigation.dialog.close
31.8.4
apex.navigation.dialog.fireCloseHandler
31.8.5
apex.navigation.dialog.registerCloseHandler
31.8.6
apex.navigation.openInNewWindow
31.8.7
apex.navigation.popup
31.8.8
apex.navigation.popup.close
31.8.9
apex.navigation.redirect
31.9
apex.page namespace
31.9.1
apex.page.cancelWarnOnUnsavedChanges
31.9.2
apex.page.confirm Signature 1
31.9.3
apex.page.confirm Signature 2
31.9.4
apex.page.submit Signature 1
31.9.5
apex.page.submit Signature 2
31.9.6
apex.page.validate
31.9.7
apex.page.isChanged
31.9.8
apex.page.warnOnUnsavedChanges
31.10
apex.region
31.10.1
apex.region
31.10.1.1
focus
31.10.1.2
refresh
31.10.1.3
widget
31.10.2
apex.region.create
31.10.3
apex.region.destroy
31.10.4
apex.region.isRegion
31.10.5
apex.region.findClosest
31.11
apex.server namespace
31.11.1
apex.server.loadScript
31.11.2
apex.server.plugin
31.11.3
apex.server.pluginUrl
31.11.4
apex.server.process
31.11.5
apex.server.url
31.12
apex.storage namespace
31.12.1
About local and session storage
31.12.2
apex.storage.getCookie
31.12.3
apex.storage.hasLocalStorageSupport
31.12.4
apex.storage.getScopedLocalStorage
31.12.5
apex.storage.getScopedSessionStorage
31.12.6
apex.storage.hasSessionStorageSupport
31.12.7
apex.storage.setCookie
31.13
apex.util namespace
31.13.1
apex.util.escapeCSS
31.13.2
apex.util.escapeHTML
31.13.3
apex.util.showSpinner
31.13.4
apex.util.stripHTML
31.13.5
apex.util.applyTemplate
31.13.6
About apex.util.delayLinger
31.13.7
apex.util.delayLinger.start
31.13.8
apex.util.delayLinger.finish
31.14
apex.widget namespace
31.14.1
apex.widget.initPageItem
31.15
Events
31.15.1
apexafterclosedialog
31.15.2
apexafterrefresh
31.15.3
apexbeforerefresh
31.15.4
apexbeforepagesubmit
31.15.5
apexbeginrecordedit
31.15.6
apexendrecordedit
31.15.7
apexpagesubmit
31.15.8
apexwindowresized
31.16
Non-namespace JavaScript APIs
31.16.1
$x
31.16.2
$v
31.16.3
$v2
31.16.4
$s
31.16.5
$u_Narray
31.16.6
$u_Carray
31.16.7
$nvl
31.16.8
$x_Style
31.16.9
$x_Hide
31.16.10
$x_Show
31.16.11
$x_Toggle
31.16.12
$x_Remove
31.16.13
$x_Value
31.16.14
$x_UpTill
31.16.15
$x_ItemRow
31.16.16
$x_HideItemRow
31.16.17
$x_ShowItemRow
31.16.18
$x_ToggleItemRow
31.16.19
$x_HideAllExcept
31.16.20
$x_HideSiblings
31.16.21
$x_ShowSiblings
31.16.22
$x_Class
31.16.23
$x_SetSiblingsClass
31.16.24
$x_ByClass
31.16.25
$x_ShowAllByClass
31.16.26
$x_ShowChildren
31.16.27
$x_HideChildren
31.16.28
$x_disableItem
31.16.29
$f_get_emptys
31.16.30
$v_Array
31.16.31
$f_ReturnChecked
31.16.32
$d_ClearAndHide
31.16.33
$f_SelectedOptions
31.16.34
$f_SelectValue
31.16.35
$u_ArrayToString
31.16.36
$x_CheckImageSrc
31.16.37
$v_CheckValueAgainst
31.16.38
$f_Hide_On_Value_Item
31.16.39
$f_Show_On_Value_Item
31.16.40
$f_Hide_On_Value_Item_Row
31.16.41
$f_Show_On_Value_Item_Row
31.16.42
$f_DisableOnValue
31.16.43
$x_ClassByClass
31.16.44
$f_ValuesToArray
31.16.45
$x_FormItems
31.16.46
$f_CheckAll
31.16.47
$f_CheckFirstColumn
31.16.48
$x_ToggleWithImage
31.16.49
$x_SwitchImageSrc
31.16.50
$x_CheckImageSrc
31.16.51
$u_SubString
31.16.52
html_RemoveAllChildren
31.16.53
html_SetSelectValue
31.16.54
addLoadEvent
31.16.55
$f_Swap
31.16.56
$f_SetValueSequence
31.16.57
$dom_AddTag
31.16.58
$tr_AddTD
31.16.59
$tr_AddTH
31.16.60
$dom_AddInput
31.16.61
$dom_MakeParent
31.16.62
$x_RowHighlight
31.16.63
$x_RowHighlightOff
31.16.64
$v_Upper
31.16.65
$d_Find
31.16.66
$f_First_field
31.17
Legacy JavaScript APIs
31.17.1
$v_PopupReturn [Deprecated]
31.17.2
$v_IsEmpty [Deprecated]
31.17.3
submitEnter [Deprecated]
31.17.4
setReturn [Deprecated]
31.17.5
GetCookie [Deprecated]
31.17.6
SetCookie [Deprecated]
32
Using REST Administration Interface API
32.1
Authentication
32.2
Individual REST Services
32.2.1
Fetch Instance-Level Statistics
32.2.2
Fetch Workspace-Level Statistics
32.2.3
Application-Level Statistics
32.2.4
Instance Overview
32.2.5
REST Service Version Information
Index
Scripting on this page enhances content navigation, but does not change the content in any way.