Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 24.1 for Oracle APEX API Reference
-
2
APEX_ACL
- 2.1 ADD_USER_ROLE Procedure Signature 1
- 2.2 ADD_USER_ROLE Procedure Signature 2
- 2.3 HAS_USER_ANY_ROLES Function
- 2.4 HAS_USER_ROLE Function
- 2.5 IS_ROLE_REMOVED_FROM_USER Function
- 2.6 REMOVE_USER_ROLE Procedure Signature 1
- 2.7 REMOVE_USER_ROLE Procedure Signature 2
- 2.8 REPLACE_USER_ROLES Procedure Signature 1
- 2.9 REPLACE_USER_ROLES Procedure Signature 2
- 2.10 REMOVE_ALL_USER_ROLES Procedure
- 3 APEX_AI
- 4 APEX_APP_SETTING
- 5 APEX_APPLICATION
-
6
APEX_APPLICATION_ADMIN
- 6.1 Constants and Data Types
- 6.2 GET_APPLICATION_ALIAS Function
- 6.3 GET_APPLICATION_NAME Function
- 6.4 GET_APPLICATION_STATUS Function
- 6.5 GET_APPLICATION_VERSION Function
- 6.6 GET_AUTHENTICATION_SCHEME Function
- 6.7 GET_BUILD_OPTION_STATUS Function Signature 1
- 6.8 GET_BUILD_OPTION_STATUS Function Signature 2
- 6.9 GET_BUILD_STATUS Function
- 6.10 GET_GLOBAL_NOTIFICATION Function
- 6.11 GET_FILE_STORAGE Function
- 6.12 GET_IMAGE_PREFIX Function
- 6.13 GET_MAX_SCHEDULER_JOBS Function
- 6.14 GET_NO_PROXY_DOMAINS Function
- 6.15 GET_PARSING_SCHEMA Function
- 6.16 GET_PASS_ECID Function
- 6.17 GET_PROXY_SERVER Function
- 6.18 SET_APPLICATION_ALIAS Procedure
- 6.19 SET_APPLICATION_NAME Procedure
- 6.20 SET_APPLICATION_STATUS Procedure
- 6.21 SET_APPLICATION_VERSION Procedure
- 6.22 SET_AUTHENTICATION_SCHEME Procedure
- 6.23 SET_BUILD_OPTION_STATUS Procedure
- 6.24 SET_BUILD_STATUS Procedure
- 6.25 SET_FILE_STORAGE Procedure
- 6.26 SET_GLOBAL_NOTIFICATION Procedure
- 6.27 SET_IMAGE_PREFIX Procedure
- 6.28 SET_MAX_SCHEDULER_JOBS Procedure
- 6.29 SET_PARSING_SCHEMA Procedure
- 6.30 SET_PASS_ECID Procedure
- 6.31 SET_PROXY_SERVER Procedure
-
7
APEX_APPLICATION_INSTALL
- 7.1 About the APEX_APPLICATION_INSTALL API
- 7.2 Attributes Manipulated by APEX_APPLICATION_INSTALL
- 7.3 Import Data Types
- 7.4 Import Script Examples
- 7.5 Public SQL Views
- 7.6 CLEAR_ALL Procedure
- 7.7 GENERATE_APPLICATION_ID Procedure
- 7.8 GENERATE_OFFSET Procedure
- 7.9 GET_APPLICATION_ALIAS Function
- 7.10 GET_APPLICATION_ID Function
- 7.11 GET_APPLICATION_NAME Function
- 7.12 GET_AUTHENTICATION_SCHEME Function
- 7.13 GET_AUTO_INSTALL_SUP_OBJ Function
- 7.14 GET_BUILD_STATUS Function
- 7.15 GET_IMAGE_PREFIX Function
- 7.16 GET_INFO Function
- 7.17 GET_KEEP_BACKGROUND_EXECS Function
- 7.18 GET_KEEP_SESSIONS Function
- 7.19 GET_MAX_SCHEDULER_JOBS Function
- 7.20 GET_NO_PROXY_DOMAINS Function
- 7.21 GET_OFFSET Function
- 7.22 GET_PASS_ECID Function
- 7.23 GET_PROXY Function
- 7.24 GET_REMOTE_SERVER_AI_ATTRS Function
- 7.25 GET_REMOTE_SERVER_AI_HEADERS Function
- 7.26 GET_REMOTE_SERVER_AI_MODEL Function
- 7.27 GET_REMOTE_SERVER_BASE_URL Function
- 7.28 GET_REMOTE_SERVER_DEFAULT_DB Function
- 7.29 GET_REMOTE_SERVER_HTTPS_HOST Function
- 7.30 GET_REMOTE_SERVER_SQL_MODE Function
- 7.31 GET_REST_SOURCE_CATALOG_GROUP Function
- 7.32 GET_SCHEMA Function
- 7.33 GET_THEME_ID Function
- 7.34 GET_WORKSPACE_ID Function
- 7.35 INSTALL Procedure
- 7.36 REMOVE_APPLICATION Procedure
- 7.37 SET_APPLICATION_ALIAS Procedure
- 7.38 SET_APPLICATION_ID Procedure
- 7.39 SET_APPLICATION_NAME Procedure
- 7.40 SET_AUTHENTICATION_SCHEME Procedure
- 7.41 SET_AUTO_INSTALL_SUP_OBJ Procedure
- 7.42 SET_BUILD_STATUS Function
- 7.43 SET_IMAGE_PREFIX Procedure
- 7.44 SET_KEEP_BACKGROUND_EXECS Procedure
- 7.45 SET_KEEP_SESSIONS Procedure
- 7.46 SET_MAX_SCHEDULER_JOBS Procedure
- 7.47 SET_OFFSET Procedure
- 7.48 SET_PASS_ECID Procedure
- 7.49 SET_PROXY Procedure
- 7.50 SET_REMOTE_SERVER Procedure
- 7.51 SET_REST_SOURCE_CATALOG_GROUP Procedure
- 7.52 SET_SCHEMA Procedure
- 7.53 SET_THEME_ID Procedure
- 7.54 SET_WORKSPACE_ID Procedure
- 7.55 SET_WORKSPACE Procedure
- 7.56 SUSPEND_BACKGROUND_EXECS Procedure
-
8
APEX_APPROVAL
- 8.1 Constants and Data Types
- 8.2 ADD_TASK_COMMENT Procedure
- 8.3 ADD_TASK_POTENTIAL_OWNER Procedure
- 8.4 ADD_TO_HISTORY Procedure
- 8.5 APPROVE_TASK Procedure
- 8.6 CANCEL_TASK Procedure
- 8.7 CLAIM_TASK Procedure
- 8.8 COMPLETE_TASK Procedure
- 8.9 CREATE_TASK Function
- 8.10 DELEGATE_TASK Procedure
- 8.11 GET_LOV_PRIORITY Function
- 8.12 GET_LOV_STATE Function
- 8.13 GET_NEXT_PURGE_TIMESTAMP Function
- 8.14 GET_TASK_DELEGATES Function
- 8.15 GET_TASK_HISTORY Function
- 8.16 GET_TASK_PARAMETER_OLD_VALUE Function
- 8.17 GET_TASK_PARAMETER_VALUE Function
- 8.18 GET_TASK_PRIORITIES Function
- 8.19 GET_TASKS Function
- 8.20 HANDLE_TASK_DEADLINES Procedure
- 8.21 HAS_TASK_PARAM_CHANGED Function
- 8.22 IS_ALLOWED Function
- 8.23 IS_BUSINESS_ADMIN Function
- 8.24 IS_OF_PARTICIPANT_TYPE Function
- 8.25 REJECT_TASK Procedure
- 8.26 RELEASE_TASK Procedure
- 8.27 REMOVE_POTENTIAL_OWNER Procedure
- 8.28 RENEW_TASK Function
- 8.29 REQUEST_MORE_INFORMATION Procedure
- 8.30 SET_INITIATOR_CAN_COMPLETE Procedure
- 8.31 SET_TASK_DUE Procedure
- 8.32 SET_TASK_PARAMETER_VALUES Procedure
- 8.33 SET_TASK_PRIORITY Procedure
- 8.34 SUBMIT_INFORMATION Procedure
-
9
APEX_AUTHENTICATION
- 9.1 Constants
- 9.2 CALLBACK Procedure
- 9.3 CALLBACK2 Procedure
- 9.4 GET_CALLBACK_URL Function
- 9.5 GET_LOGIN_USERNAME_COOKIE Function
- 9.6 IS_AUTHENTICATED Function
- 9.7 IS_PUBLIC_USER Function
- 9.8 LOGIN Procedure
- 9.9 LOGOUT Procedure
- 9.10 PERSISTENT_AUTH_ENABLED Function
- 9.11 PERSISTENT_COOKIES_ENABLED Function
- 9.12 POST_LOGIN Procedure
- 9.13 REMOVE_CURRENT_PERSISTENT_AUTH Procedure
- 9.14 REMOVE_PERSISTENT_AUTH Procedure
- 9.15 SAML_CALLBACK Procedure
- 9.16 SAML_METADATA Procedure
- 9.17 SEND_LOGIN_USERNAME_COOKIE Procedure
- 10 APEX_AUTHORIZATION
-
11
APEX_AUTOMATION
- 11.1 ABORT Procedure (Deprecated)
- 11.2 DISABLE Procedure
- 11.3 ENABLE Procedure
- 11.4 EXECUTE Procedure Signature 1
- 11.5 EXECUTE Procedure Signature 2
- 11.6 EXECUTE for Query Context Procedure
- 11.7 EXIT Procedure
- 11.8 GET_LAST_RUN Function
- 11.9 GET_LAST_RUN_TIMESTAMP Function
- 11.10 GET_SCHEDULER_JOB_NAME Function
- 11.11 IS_RUNNING Function
- 11.12 LOG_ERROR Procedure
- 11.13 LOG_INFO Procedure
- 11.14 LOG_WARN Procedure
- 11.15 RESCHEDULE Procedure
- 11.16 SKIP_CURRENT_ROW Procedure
- 11.17 TERMINATE Procedure
-
12
APEX_BACKGROUND_PROCESS
- 12.1 Constants
- 12.2 Data Types
- 12.3 ABORT Procedure Signature 1 (Deprecated)
- 12.4 ABORT Procedure Signature 2 (Deprecated)
- 12.5 GET_CURRENT_EXECUTION Function
- 12.6 GET_EXECUTION Function
- 12.7 SET_PROGRESS Procedure
- 12.8 SET_STATUS Procedure
- 12.9 TERMINATE Procedure Signature 1
- 12.10 TERMINATE Procedure Signature 2
- 13 APEX_BARCODE
-
14
APEX_COLLECTION
- 14.1 About the APEX_COLLECTION API
- 14.2 Naming Collections
- 14.3 Creating a Collection
- 14.4 About the Parameter p_generate_md5
- 14.5 Accessing a Collection
- 14.6 Merging Collections
- 14.7 Truncating a Collection
- 14.8 Deleting a Collection
- 14.9 Deleting All Collections for the Current Application
- 14.10 Deleting All Collections in the Current Session
- 14.11 Adding Members to a Collection
- 14.12 About the Parameters p_generate_md5, p_clob001, p_blob001, and p_xmltype001
- 14.13 Updating Collection Members
- 14.14 Deleting Collection Members
- 14.15 Obtaining a Member Count
- 14.16 Resequencing a Collection
- 14.17 Verifying Whether a Collection Exists
- 14.18 Adjusting a Member Sequence ID
- 14.19 Sorting Collection Members
- 14.20 Clearing Collection Session State
- 14.21 Determining Collection Status
- 14.22 ADD_MEMBER Procedure
- 14.23 ADD_MEMBER Function
- 14.24 ADD_MEMBERS Procedure
- 14.25 COLLECTION_EXISTS Function
- 14.26 COLLECTION_HAS_CHANGED Function
- 14.27 COLLECTION_MEMBER_COUNT Function
- 14.28 CREATE_COLLECTION Procedure
- 14.29 CREATE_OR_TRUNCATE_COLLECTION Procedure
- 14.30 CREATE_COLLECTION_FROM_QUERY Procedure
- 14.31 CREATE_COLLECTION_FROM_QUERY2 Procedure
- 14.32 CREATE_COLLECTION_FROM_QUERY_B Procedure
- 14.33 CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
- 14.34 CREATE_COLLECTION_FROM_QUERYB2 Procedure
- 14.35 CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
- 14.36 DELETE_ALL_COLLECTIONS Procedure
- 14.37 DELETE_ALL_COLLECTIONS_SESSION Procedure
- 14.38 DELETE_COLLECTION Procedure
- 14.39 DELETE_MEMBER Procedure
- 14.40 DELETE_MEMBERS Procedure
- 14.41 GET_MEMBER_MD5 Function
- 14.42 MERGE_MEMBERS Procedure
- 14.43 MOVE_MEMBER_DOWN Procedure
- 14.44 MOVE_MEMBER_UP Procedure
- 14.45 RESEQUENCE_COLLECTION Procedure
- 14.46 RESET_COLLECTION_CHANGED Procedure
- 14.47 RESET_COLLECTION_CHANGED_ALL Procedure
- 14.48 SORT_MEMBERS Procedure
- 14.49 TRUNCATE_COLLECTION Procedure
- 14.50 UPDATE_MEMBER Procedure
- 14.51 UPDATE_MEMBERS Procedure
- 14.52 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
- 14.53 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
- 14.54 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
- 14.55 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
- 14.56 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
- 14.57 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6
-
15
APEX_CREDENTIAL
- 15.1 CLEAR_TOKENS Procedure
- 15.2 CREATE_CREDENTIAL Procedure Signature 1
- 15.3 CREATE_CREDENTIAL Procedure Signature 2
- 15.4 DROP_CREDENTIAL Procedure
- 15.5 SET_ALLOWED_URLS Procedure
- 15.6 SET_DATABASE_CREDENTIAL Procedure
- 15.7 SET_PERSISTENT_CREDENTIALS Procedure Signature 1
- 15.8 SET_PERSISTENT_CREDENTIALS Procedure Signature 2
- 15.9 SET_PERSISTENT_TOKEN Procedure
- 15.10 SET_SESSION_CREDENTIALS Procedure Signature 1
- 15.11 SET_SESSION_CREDENTIALS Procedure Signature 2
- 15.12 SET_SESSION_CREDENTIALS Procedure Signature 3
- 15.13 SET_SESSION_TOKEN Procedure
- 16 APEX_CSS
-
17
APEX_CUSTOM_AUTH
- 17.1 APPLICATION_PAGE_ITEM_EXISTS Function
- 17.2 CURRENT_PAGE_IS_PUBLIC Function
- 17.3 DEFINE_USER_SESSION Procedure
- 17.4 GET_COOKIE_PROPS Procedure
- 17.5 GET_LDAP_PROPS Procedure
- 17.6 GET_NEXT_SESSION_ID Function
- 17.7 GET_SECURITY_GROUP_ID Function
- 17.8 GET_SESSION_ID Function
- 17.9 GET_SESSION_ID_FROM_COOKIE Function
- 17.10 GET_USER Function
- 17.11 GET_USERNAME Function
- 17.12 IS_SESSION_VALID Function
- 17.13 LDAP_DNPREP Function
- 17.14 LOGIN Procedure
- 17.15 LOGOUT Procedure [DEPRECATED]
- 17.16 POST_LOGIN Procedure
- 17.17 SESSION_ID_EXISTS Function
- 17.18 SET_SESSION_ID Procedure
- 17.19 SET_SESSION_ID_TO_NEXT_VALUE Procedure
- 17.20 SET_USER Procedure
- 18 APEX_DATA_LOADING
- 19 APEX_DATA_EXPORT
- 20 APEX_DATA_INSTALL
- 21 APEX_DATA_PARSER
-
22
APEX_DEBUG
- 22.1 Constants
- 22.2 DISABLE Procedure
- 22.3 DISABLE_DBMS_OUTPUT Procedure
- 22.4 ENABLE Procedure
- 22.5 ENTER Procedure
- 22.6 ENABLE_DBMS_OUTPUT Procedure
- 22.7 ERROR Procedure
- 22.8 GET_LAST_MESSAGE_ID Function
- 22.9 GET_PAGE_VIEW_ID Function
- 22.10 INFO Procedure
- 22.11 LOG_DBMS_OUTPUT Procedure
- 22.12 LOG_LONG_MESSAGE Procedure
- 22.13 LOG_MESSAGE Procedure [Deprecated]
- 22.14 LOG_PAGE_SESSION_STATE Procedure
- 22.15 MESSAGE Procedure
- 22.16 REMOVE_DEBUG_BY_AGE Procedure
- 22.17 REMOVE_DEBUG_BY_APP Procedure
- 22.18 REMOVE_DEBUG_BY_VIEW Procedure
- 22.19 REMOVE_SESSION_MESSAGES Procedure
- 22.20 TOCHAR Function
- 22.21 TRACE Procedure
- 22.22 WARN Procedure
-
23
APEX_DG_DATA_GEN
- 23.1 ADD_BLUEPRINT Procedure
- 23.2 ADD_BLUEPRINT_FROM_FILE Procedure
- 23.3 ADD_BLUEPRINT_FROM_TABLES Procedure
- 23.4 ADD_COLUMN Procedure
- 23.5 ADD_DATA_SOURCE Procedure
- 23.6 ADD_TABLE Procedure
- 23.7 EXPORT_BLUEPRINT Function
- 23.8 GENERATE_DATA Procedure Signature 1
- 23.9 GENERATE_DATA Procedure Signature 2
- 23.10 GENERATE_DATA_INTO_COLLECTION Procedure
- 23.11 GET_BLUEPRINT_ID Function
- 23.12 GET_BP_TABLE_ID Function
- 23.13 GET_EXAMPLE Function
- 23.14 GET_WEIGHTED_INLINE_DATA Function
- 23.15 IMPORT_BLUEPRINT Procedure
- 23.16 PREVIEW_BLUEPRINT Procedure
- 23.17 REMOVE_BLUEPRINT Procedure
- 23.18 REMOVE_COLUMN Procedure
- 23.19 REMOVE_DATA_SOURCE Procedure
- 23.20 REMOVE_TABLE Procedure
- 23.21 RESEQUENCE_BLUEPRINT Procedure
- 23.22 STOP_DATA_GENERATION Procedure
- 23.23 UPDATE_BLUEPRINT Procedure
- 23.24 UPDATE_COLUMN Procedure
- 23.25 UPDATE_DATA_SOURCE Procedure
- 23.26 UPDATE_TABLE Procedure
- 23.27 VALIDATE_BLUEPRINT Procedure
- 23.28 VALIDATE_INSTANCE_SETTING Procedure
-
24
APEX_ERROR
- 24.1 Constants and Attributes Used for Result Types
- 24.2 Example of an Error Handling Function
- 24.3 ADD_ERROR Procedure Signature 1
- 24.4 ADD_ERROR Procedure Signature 2
- 24.5 ADD_ERROR Procedure Signature 3
- 24.6 ADD_ERROR Procedure Signature 4
- 24.7 ADD_ERROR Procedure Signature 5
- 24.8 AUTO_SET_ASSOCIATED_ITEM Procedure
- 24.9 EXTRACT_CONSTRAINT_NAME Function
- 24.10 GET_FIRST_ORA_ERROR_TEXT Function
- 24.11 HAVE_ERRORS_OCCURRED Function
- 24.12 INIT_ERROR_RESULT Function
-
25
APEX_ESCAPE
- 25.1 Constants
- 25.2 CSS_SELECTOR Function
- 25.3 CSV Function Signature 1
- 25.4 CSV Function Signature 2
- 25.5 GET_CSV_ENCLOSED_BY Function
- 25.6 GET_CSV_SEPARATED_BY Function
- 25.7 HTML Function
- 25.8 HTML_ALLOWLIST Function
- 25.9 HTML_ALLOWLIST_CLOB Function
- 25.10 HTML_ATTRIBUTE Function
- 25.11 HTML_ATTRIBUTE_CLOB Function
- 25.12 HTML_CLOB Function
- 25.13 HTML_TRUNC Function Signature 1
- 25.14 HTML_TRUNC Function Signature 2
- 25.15 JS_LITERAL Function
- 25.16 JS_LITERAL_CLOB Function
- 25.17 JSON Function
- 25.18 JSON_CLOB Function
- 25.19 LDAP_DN Function
- 25.20 LDAP_SEARCH_FILTER Function
- 25.21 NOOP Function Signature 1
- 25.22 NOOP Function Signature 2
- 25.23 REGEXP Function
- 25.24 SET_CSV_PARAMETERS Procedure
- 25.25 SET_HTML_ESCAPING_MODE Procedure
- 25.26 STRIPHTML Function Signature 1
- 25.27 STRIPHTML Function Signature 2
-
26
APEX_EXEC
- 26.1 Call Sequences for APEX_EXEC
- 26.2 Global Constants
- 26.3 Data Types
- 26.4 ADD_COLUMN Procedure
- 26.5 ADD_DML_ARRAY_ROW Procedure
- 26.6 ADD_DML_ROW Procedure
- 26.7 ADD_FILTER Procedure Signature 1
- 26.8 ADD_ORDER_BY Procedure
- 26.9 ADD_PARAMETER Procedure
- 26.10 CLEAR_DML_ROWS Procedure
- 26.11 CLOSE Procedure
- 26.12 CLOSE_ARRAY Procedure
- 26.13 COLUMN_EXISTS Function
- 26.14 COPY_DATA Procedure
- 26.15 DESCRIBE_QUERY Function Signature 1
- 26.16 DESCRIBE_QUERY Function Signature 2
- 26.17 ENQUOTE_LITERAL Function
- 26.18 ENQUOTE_NAME Function
- 26.19 EXECUTE_DML Procedure
- 26.20 EXECUTE_PLSQL Procedure
- 26.21 EXECUTE_REMOTE_PLSQL Procedure
- 26.22 EXECUTE_REST_SOURCE Procedure Signature 1
- 26.23 EXECUTE_REST_SOURCE Procedure Signature 2
- 26.24 EXECUTE_WEB_SOURCE Procedure (Deprecated)
- 26.25 GET Functions
- 26.26 GET_ARRAY_ROW_DML_OPERATION Function
- 26.27 GET_ARRAY_ROW_VERSION_CHECKSUM Function
- 26.28 GET_COLUMN Function
- 26.29 GET_COLUMNS Function
- 26.30 GET_COLUMN_COUNT Function
- 26.31 GET_COLUMN_POSITION Function
- 26.32 GET_DATA_TYPE Function
- 26.33 GET_DML_STATUS_CODE Function
- 26.34 GET_DML_STATUS_MESSAGE Function
- 26.35 GET_PARAMETER Functions
- 26.36 GET_ROW_VERSION_CHECKSUM Function
- 26.37 GET_TOTAL_ROW_COUNT Function
- 26.38 HAS_ERROR Function
- 26.39 HAS_MORE_ARRAY_ROWS Function
- 26.40 HAS_MORE_ROWS Function
- 26.41 IS_REMOTE_SQL_AUTH_VALID Function
- 26.42 NEXT_ARRAY_ROW Function
- 26.43 NEXT_ROW Function
- 26.44 OPEN_ARRAY Procedure
- 26.45 OPEN_LOCAL_DML_CONTEXT Function
- 26.46 OPEN_QUERY_CONTEXT Function Signature 1
- 26.47 OPEN_QUERY_CONTEXT Function Signature 2
- 26.48 OPEN_REMOTE_DML_CONTEXT Function
- 26.49 OPEN_REMOTE_SQL_QUERY Function
- 26.50 OPEN_REST_SOURCE_DML_CONTEXT Function
- 26.51 OPEN_REST_SOURCE_QUERY Function
- 26.52 OPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated)
- 26.53 OPEN_WEB_SOURCE_QUERY Function (Deprecated)
- 26.54 PURGE_REST_SOURCE_CACHE Procedure
- 26.55 PURGE_WEB_SOURCE_CACHE Procedure (Deprecated)
- 26.56 SET_ARRAY_CURRENT_ROW Procedure
- 26.57 SET_ARRAY_ROW_VERSION_CHECKSUM Procedure
- 26.58 SET_CURRENT_ROW Procedure
- 26.59 SET_NULL Procedure
- 26.60 SET_ROW_VERSION_CHECKSUM Procedure
- 26.61 SET_VALUE Procedure
- 26.62 SET_VALUES Procedure
- 27 APEX_EXPORT
- 28 APEX_EXTENSION
- 29 APEX_HTTP
-
30
APEX_HUMAN_TASK
- 30.1 Constants and Data Types
- 30.2 ADD_TASK_COMMENT Procedure
- 30.3 ADD_TASK_POTENTIAL_OWNER Procedure
- 30.4 ADD_TO_HISTORY Procedure
- 30.5 APPROVE_TASK Procedure
- 30.6 CANCEL_TASK Procedure
- 30.7 CLAIM_TASK Procedure
- 30.8 COMPLETE_TASK Procedure
- 30.9 CREATE_TASK Function
- 30.10 DELEGATE_TASK Procedure
- 30.11 GET_LOV_PRIORITY Function
- 30.12 GET_LOV_STATE Function
- 30.13 GET_TASK_DELEGATES Function
- 30.14 GET_TASK_HISTORY Function
- 30.15 GET_TASK_PARAMETER_OLD_VALUE Function
- 30.16 GET_TASK_PARAMETER_VALUE Function
- 30.17 GET_TASK_PRIORITIES Function
- 30.18 GET_TASKS Function
- 30.19 HANDLE_TASK_DEADLINES Procedure
- 30.20 HAS_TASK_PARAM_CHANGED Function
- 30.21 IS_ALLOWED Function
- 30.22 IS_BUSINESS_ADMIN Function
- 30.23 IS_OF_PARTICIPANT_TYPE Function
- 30.24 REJECT_TASK Procedure
- 30.25 RELEASE_TASK Procedure
- 30.26 REMOVE_POTENTIAL_OWNER Procedure
- 30.27 RENEW_TASK Function
- 30.28 REQUEST_MORE_INFORMATION Procedure
- 30.29 SET_TASK_DUE Procedure
- 30.30 SET_TASK_PARAMETER_VALUES Procedure
- 30.31 SET_TASK_PRIORITY Procedure
- 30.32 SUBMIT_INFORMATION Procedure
-
31
APEX_INSTANCE_ADMIN
- 31.1 Available Parameter Values
- 31.2 ADD_AUTO_PROV_RESTRICTIONS Procedure
- 31.3 ADD_SCHEMA Procedure
- 31.4 ADD_WEB_ENTRY_POINT Procedure
- 31.5 ADD_WORKSPACE Procedure
- 31.6 CREATE_CLOUD_CREDENTIAL Procedure
- 31.7 CREATE_OR_UPDATE_ADMIN_USER Procedure
- 31.8 CREATE_SCHEMA_EXCEPTION Procedure
- 31.9 DB_SIGNATURE Function
- 31.10 DROP_CLOUD_CREDENTIAL Procedure
- 31.11 FREE_WORKSPACE_APP_IDS Procedure
- 31.12 GET_PARAMETER Function
- 31.13 GET_SCHEMAS Function
- 31.14 GET_WORKSPACE_PARAMETER Procedure
- 31.15 IS_DB_SIGNATURE_VALID Function
- 31.16 REMOVE_APPLICATION Procedure
- 31.17 REMOVE_AUTO_PROV_RESTRICTIONS Procedure
- 31.18 REMOVE_SAVED_REPORT Procedure
- 31.19 REMOVE_SAVED_REPORTS Procedure
- 31.20 REMOVE_SCHEMA Procedure
- 31.21 REMOVE_SCHEMA_EXCEPTION Procedure
- 31.22 REMOVE_SCHEMA_EXCEPTIONS Procedure
- 31.23 REMOVE_SUBSCRIPTION Procedure
- 31.24 REMOVE_WEB_ENTRY_POINT Procedure
- 31.25 REMOVE_WORKSPACE Procedure
- 31.26 REMOVE_WORKSPACE_EXCEPTIONS Procedure
- 31.27 RESERVE_WORKSPACE_APP_IDS Procedure
- 31.28 RESTRICT_SCHEMA Procedure
- 31.29 SET_LOG_SWITCH_INTERVAL Procedure
- 31.30 SET_PARAMETER Procedure
- 31.31 SET_WORKSPACE_CONSUMER_GROUP Procedure
- 31.32 SET_WORKSPACE_PARAMETER Procedure
- 31.33 TRUNCATE_LOG Procedure
- 31.34 UNLOCK_USER Procedure
- 31.35 UNRESTRICT_SCHEMA Procedure
- 31.36 VALIDATE_EMAIL_CONFIG Procedure
-
32
APEX_IG
- 32.1 ADD_FILTER Procedure Signature 1
- 32.2 ADD_FILTER Procedure Signature 2
- 32.3 CHANGE_REPORT_OWNER Procedure
- 32.4 CLEAR_REPORT Procedure Signature 1
- 32.5 CLEAR_REPORT Procedure Signature 2
- 32.6 DELETE_REPORT Procedure
- 32.7 GET_LAST_VIEWED_REPORT_ID Function
- 32.8 RESET_REPORT Procedure Signature 1
- 32.9 RESET_REPORT Procedure Signature 2
-
33
APEX_IR
- 33.1 ADD_FILTER Procedure Signature 1
- 33.2 ADD_FILTER Procedure Signature 2
- 33.3 CHANGE_REPORT_OWNER Procedure
- 33.4 CHANGE_SUBSCRIPTION_EMAIL Procedure
- 33.5 CHANGE_SUBSCRIPTION_LANG Procedure
- 33.6 CLEAR_REPORT Procedure Signature 1
- 33.7 CLEAR_REPORT Procedure Signature 2
- 33.8 CLONE_REPORT Function
- 33.9 DELETE_REPORT Procedure
- 33.10 DELETE_SUBSCRIPTION Procedure
- 33.11 EXPORT_SAVED_REPORTS Function
- 33.12 GET_LAST_VIEWED_REPORT_ID Function
- 33.13 GET_REPORT Function (Deprecated)
- 33.14 IMPORT_SAVED_REPORTS Procedure
- 33.15 RESET_REPORT Procedure Signature 1
- 33.16 RESET_REPORT Procedure Signature 2
-
34
APEX_ITEM (Legacy)
- 34.1 CHECKBOX2 Function
- 34.2 DATE_POPUP Function
- 34.3 DATE_POPUP2 Function
- 34.4 DISPLAY_AND_SAVE Function
- 34.5 HIDDEN Function
- 34.6 MD5_CHECKSUM Function
- 34.7 MD5_HIDDEN Function
- 34.8 POPUP_FROM_LOV Function
- 34.9 POPUP_FROM_QUERY Function
- 34.10 POPUPKEY_FROM_LOV Function
- 34.11 POPUPKEY_FROM_QUERY Function
- 34.12 RADIOGROUP Function
- 34.13 SELECT_LIST Function
- 34.14 SELECT_LIST_FROM_LOV Function
- 34.15 SELECT_LIST_FROM_LOV_XL Function
- 34.16 SELECT_LIST_FROM_QUERY Function
- 34.17 SELECT_LIST_FROM_QUERY_XL Function
- 34.18 SWITCH Function
- 34.19 TEXT Function
- 34.20 TEXTAREA Function
- 34.21 TEXT_FROM_LOV Function
- 34.22 TEXT_FROM_LOV_QUERY Function
-
35
APEX_JAVASCRIPT
- 35.1 ADD_3RD_PARTY_LIBRARY_FILE Procedure (Deprecated)
- 35.2 ADD_ATTRIBUTE Function Signature 1
- 35.3 ADD_ATTRIBUTE Function Signature 2
- 35.4 ADD_ATTRIBUTE Function Signature 3
- 35.5 ADD_ATTRIBUTE Function Signature 4
- 35.6 ADD_INLINE_CODE Procedure
- 35.7 ADD_JET Procedure
- 35.8 ADD_LIBRARY Procedure
- 35.9 ADD_REQUIREJS Procedure
- 35.10 ADD_REQUIREJS_DEFINE Procedure
- 35.11 ADD_ONLOAD_CODE Procedure
- 35.12 ADD_VALUE Function Signature 1
- 35.13 ADD_VALUE Function Signature 2
- 35.14 ADD_VALUE Function Signature 3
- 35.15 ADD_VALUE Function Signature 4
- 35.16 Escape Function
-
36
APEX_JSON
- 36.1 Package Overview and Examples
- 36.2 Constants and Data Types
- 36.3 CLOSE_ALL Procedure
- 36.4 CLOSE_ARRAY Procedure
- 36.5 CLOSE_OBJECT Procedure
- 36.6 DOES_EXIST Function
- 36.7 FIND_PATHS_LIKE Function
- 36.8 FLUSH Procedure
- 36.9 FREE_OUTPUT Procedure
- 36.10 GET_BOOLEAN Function
- 36.11 GET_CLOB Function
- 36.12 GET_CLOB_OUTPUT Function
- 36.13 GET_COUNT Function
- 36.14 GET_DATE Function
- 36.15 GET_MEMBERS Function
- 36.16 GET_NUMBER Function
- 36.17 GET_SDO_GEOMETRY Function
- 36.18 GET_T_NUMBER Function
- 36.19 GET_T_VARCHAR2 Function
- 36.20 GET_VALUE Function
- 36.21 GET_VALUE_KIND Function
- 36.22 GET_VARCHAR2 Function
- 36.23 INITIALIZE_CLOB_OUTPUT Procedure
- 36.24 INITIALIZE_OUTPUT Procedure
- 36.25 OPEN_ARRAY Procedure
- 36.26 OPEN_OBJECT Procedure
- 36.27 PARSE Procedure Signature 1
- 36.28 PARSE Procedure Signature 2
- 36.29 STRINGIFY Function Signature 1
- 36.30 STRINGIFY Function Signature 2
- 36.31 STRINGIFY Function Signature 3
- 36.32 STRINGIFY Function Signature 4
- 36.33 STRINGIFY Function Signature 5
- 36.34 TO_MEMBER_NAME Function
- 36.35 TO_XMLTYPE Function
- 36.36 TO_XMLTYPE_SQL Function
- 36.37 WRITE Procedure Signature 1
- 36.38 WRITE Procedure Signature 2
- 36.39 WRITE Procedure Signature 3
- 36.40 WRITE Procedure Signature 4
- 36.41 WRITE Procedure Signature 5
- 36.42 WRITE Procedure Signature 6
- 36.43 WRITE Procedure Signature 7
- 36.44 WRITE Procedure Signature 8
- 36.45 WRITE Procedure Signature 9
- 36.46 WRITE Procedure Signature 10
- 36.47 WRITE Procedure Signature 11
- 36.48 WRITE Procedure Signature 12
- 36.49 WRITE Procedure Signature 13
- 36.50 WRITE Procedure Signature 14
- 36.51 WRITE Procedure Signature 15
- 36.52 WRITE Procedure Signature 16
- 36.53 WRITE Procedure Signature 17
- 36.54 WRITE Procedure Signature 18
- 36.55 WRITE Procedure Signature 19
- 36.56 WRITE Procedure Signature 20
- 36.57 WRITE Procedure Signature 21
- 36.58 WRITE_CONTEXT Procedure
- 37 APEX_JWT
-
38
APEX_LANG
- 38.1 APPLY_XLIFF_DOCUMENT Procedure
- 38.2 CREATE_LANGUAGE_MAPPING Procedure
- 38.3 CREATE_MESSAGE Procedure
- 38.4 DELETE_LANGUAGE_MAPPING Procedure
- 38.5 DELETE_MESSAGE Procedure
- 38.6 EMIT_LANGUAGE_SELECTOR_LIST Procedure
- 38.7 GET_LANGUAGE_SELECTOR_LIST Function
- 38.8 GET_XLIFF_DOCUMENT Function
- 38.9 LANG Function
- 38.10 MESSAGE Function
- 38.11 PUBLISH_APPLICATION Procedure
- 38.12 SEED_TRANSLATIONS Procedure
- 38.13 UPDATE_LANGUAGE_MAPPING Procedure
- 38.14 UPDATE_MESSAGE Procedure
- 38.15 UPDATE_TRANSLATED_STRING Procedure
- 39 APEX_LDAP
-
40
APEX_MAIL
- 40.1 Configuring Oracle APEX to Send Email
- 40.2 ADD_ATTACHMENT Procedure Signature 1
- 40.3 ADD_ATTACHMENT Procedure Signature 2
- 40.4 GET_IMAGES_URL Function
- 40.5 GET_INSTANCE_URL Function
- 40.6 PREPARE_TEMPLATE Procedure
- 40.7 PUSH_QUEUE Procedure
- 40.8 SEND Function Signature 1
- 40.9 SEND Function Signature 2
- 40.10 SEND Procedure Signature 1
- 40.11 SEND Procedure Signature 2
- 41 APEX_MARKDOWN
- 42 APEX_PAGE
-
43
APEX_PLUGIN
-
43.1
Data Types
- 43.1.1 c_inline_in_notification
- 43.1.2 c_inline_with_field
- 43.1.3 c_inline_with_field_and_notif
- 43.1.4 c_on_error_page
- 43.1.5 t_authentication
- 43.1.6 t_authentication_ajax_result
- 43.1.7 t_authentication_auth_result
- 43.1.8 t_authentication_inval_result
- 43.1.9 t_authentication_logout_result
- 43.1.10 t_authentication_sentry_result
- 43.1.11 t_authorization
- 43.1.12 t_authorization_exec_result
- 43.1.13 t_dynamic_action
- 43.1.14 t_dynamic_action_ajax_result
- 43.1.15 t_dynamic_action_render_result
- 43.1.16 t_item
- 43.1.17 t_item_ajax_result
- 43.1.18 t_item_meta_data_result
- 43.1.19 t_item_render_result
- 43.1.20 t_item_validation_result
- 43.1.21 t_plugin
- 43.1.22 t_plugin_attributes
- 43.1.23 t_process
- 43.1.24 t_process_exec_result
- 43.1.25 t_region
- 43.1.26 t_region_ajax_result
- 43.1.27 t_region_column
- 43.1.28 t_region_columns
- 43.1.29 t_region_render_param
- 43.1.30 t_region_render_result
- 43.2 Global Constants
- 43.3 GET_AJAX_IDENTIFIER Function
- 43.4 GET_INPUT_NAME_FOR_PAGE_ITEM Function (Deprecated)
-
43.1
Data Types
-
44
APEX_PLUGIN_UTIL
- 44.1 BUILD_REQUEST_BODY Procedure
- 44.2 CLEAR_COMPONENT_VALUES Procedure
- 44.3 CURRENT_ROW_CHANGED Function
- 44.4 DB_OPERATION_ALLOWED Function
- 44.5 DEBUG_DYNAMIC _ACTION Procedure
- 44.6 DEBUG_PAGE_ITEM Procedure Signature 1
- 44.7 DEBUG_PAGE_ITEM Procedure Signature 2
- 44.8 DEBUG_PROCESS Procedure
- 44.9 DEBUG_REGION Procedure Signature 1
- 44.10 DEBUG_REGION Procedure Signature 2
- 44.11 ESCAPE Function
- 44.12 EXECUTE_PLSQL_CODE Procedure
- 44.13 GET_ATTRIBUTE_AS_NUMBER Function
- 44.14 GET_CURRENT_DATABASE_TYPE Function
- 44.15 GET_DATA Function Signature 1
- 44.16 GET_DATA Function Signature 2
- 44.17 GET_DATA2 Function Signature 1
- 44.18 GET_DATA2 Function Signature 2
- 44.19 GET_DISPLAY_DATA Function Signature 1
- 44.20 GET_DISPLAY_DATA Function Signature 2
- 44.21 GET_ELEMENT_ATTRIBUTES Function
- 44.22 GET_HTML_ATTR Function
- 44.23 GET_ORDERBY_NULLS_SUPPORT Function
- 44.24 GET_PLSQL_EXPR_RESULT_BOOLEAN Function
- 44.25 GET_PLSQL_EXPR_RESULT_CLOB Function
- 44.26 GET_PLSQL_EXPRESSION_RESULT Function
- 44.27 GET_PLSQL_FUNC_RESULT_BOOLEAN Function
- 44.28 GET_PLSQL_FUNC_RESULT_CLOB Function
- 44.29 GET_PLSQL_FUNCTION_RESULT Function
- 44.30 GET_POSITION_IN_LIST Function
- 44.31 GET_SEARCH_STRING Function
- 44.32 GET_VALUE_AS_VARCHAR2 Function
- 44.33 GET_WEB_SOURCE_OPERATION Function
- 44.34 IS_EQUAL Function
- 44.35 IS_COMPONENT_USED Function
- 44.36 MAKE_REST_REQUEST Procedure Signature 1
- 44.37 MAKE_REST_REQUEST Procedure Signature 2
- 44.38 PAGE_ITEM_NAMES_TO_JQUERY Function
- 44.39 PARSE_REFETCH_RESPONSE Function
- 44.40 PRINT_DISPLAY_ONLY Procedure Signature 1 (Deprecated)
- 44.41 PRINT_DISPLAY_ONLY Procedure Signature 2 (Deprecated)
- 44.42 PRINT_ESCAPED_VALUE Procedure Signature 1
- 44.43 PRINT_ESCAPED_VALUE Procedure Signature 2
- 44.44 PRINT_HIDDEN Procedure
- 44.45 PRINT_HIDDEN_IF_READONLY Procedure
- 44.46 PRINT_JSON_HTTP_HEADER Procedure
- 44.47 PRINT_LOV_AS_JSON Procedure
- 44.48 PRINT_OPTION Procedure
- 44.49 PRINT_READ_ONLY Procedure Signature 1
- 44.50 PRINT_READ_ONLY Procedure Signature 2
- 44.51 PROCESS_DML_RESPONSE Procedure
- 44.52 REPLACE_SUBSTITUTIONS Function
- 44.53 SET_COMPONENT_VALUES Procedure
- 44.54 SPLIT_MUTLIPLE_VALUE_TO_TABLE Function
- 45 APEX_PRINT
- 46 APEX_PWA
- 47 APEX_REGION
- 48 APEX_REST_SOURCE_SYNC
- 49 APEX_SEARCH
- 50 APEX_SESSION
- 51 APEX_SESSION_STATE
- 52 APEX_SPATIAL
-
53
APEX_STRING
- 53.1 FORMAT Function
- 53.2 GET_INITIALS Function
- 53.3 GET_SEARCHABLE_PHRASES Function
- 53.4 GREP Function Signature 1
- 53.5 GREP Function Signature 2
- 53.6 GREP Function Signature 3
- 53.7 INDEX_OF Function Signature 1
- 53.8 INDEX_OF Function Signature 2
- 53.9 JOIN_CLOB Function
- 53.10 JOIN_CLOBS Function
- 53.11 JOIN Function Signature 1
- 53.12 JOIN Function Signature 2
- 53.13 NEXT_CHUNK Function
- 53.14 PLIST_DELETE Procedure
- 53.15 PLIST_GET Function
- 53.16 PLIST_PUSH Procedure
- 53.17 PLIST_PUT Function
- 53.18 PLIST_TO_JSON_CLOB Function
- 53.19 PUSH Procedure Signature 1
- 53.20 PUSH Procedure Signature 2
- 53.21 PUSH Procedure Signature 3
- 53.22 PUSH Procedure Signature 4
- 53.23 PUSH Procedure Signature 5
- 53.24 PUSH Procedure Signature 6
- 53.25 PUSH Procedure Signature 7
- 53.26 SHUFFLE Function
- 53.27 SHUFFLE Procedure
- 53.28 SPLIT Function Signature 1
- 53.29 SPLIT Function Signature 2
- 53.30 SPLIT_CLOBS Function
- 53.31 SPLIT_NUMBERS Function
- 53.32 STRING_TO_TABLE Function
- 53.33 TABLE_TO_CLOB Function
- 53.34 TABLE_TO_STRING Function
-
54
APEX_STRING_UTIL
- 54.1 DIFF Function
- 54.2 FIND_EMAIL_ADDRESSES Function
- 54.3 FIND_EMAIL_FROM Function
- 54.4 FIND_EMAIL_SUBJECT Function
- 54.5 FIND_IDENTIFIERS Function
- 54.6 FIND_LINKS Function
- 54.7 FIND_PHRASES Function
- 54.8 FIND_TAGS Function
- 54.9 GET_DOMAIN Function
- 54.10 GET_FILE_EXTENSION Function
- 54.11 GET_SLUG Function
- 54.12 PHRASE_EXISTS Function
- 54.13 REPLACE_WHITESPACE Function
- 54.14 TO_DISPLAY_FILESIZE Function
- 55 APEX_THEME
-
56
APEX_UI_DEFAULT_UPDATE
- 56.1 ADD_AD_COLUMN Procedure
- 56.2 ADD_AD_SYNONYM Procedure
- 56.3 DEL_AD_COLUMN Procedure
- 56.4 DEL_AD_SYNONYM Procedure
- 56.5 DEL_COLUMN Procedure
- 56.6 DEL_GROUP Procedure
- 56.7 DEL_TABLE Procedure
- 56.8 SYNCH_TABLE Procedure
- 56.9 UPD_AD_COLUMN Procedure
- 56.10 UPD_AD_SYNONYM Procedure
- 56.11 UPD_COLUMN Procedure
- 56.12 UPD_DISPLAY_IN_FORM Procedure
- 56.13 UPD_DISPLAY_IN_REPORT Procedure
- 56.14 UPD_FORM_REGION_TITLE Procedure
- 56.15 UPD_GROUP Procedure
- 56.16 UPD_ITEM_DISPLAY_HEIGHT Procedure
- 56.17 UPD_ITEM_DISPLAY_WIDTH Procedure
- 56.18 UPD_ITEM_FORMAT_MASK Procedure
- 56.19 UPD_ITEM_HELP Procedure
- 56.20 UPD_LABEL Procedure
- 56.21 UPD_REPORT_ALIGNMENT Procedure
- 56.22 UPD_REPORT_FORMAT_MASK Procedure
- 56.23 UPD_REPORT_REGION_TITLE Procedure
- 56.24 UPD_TABLE Procedure
-
57
APEX_UTIL
- 57.1 BLOB_TO_CLOB Function
- 57.2 CACHE_GET_DATE_OF_PAGE_CACHE Function
- 57.3 CACHE_GET_DATE_OF_REGION_CACHE Function
- 57.4 CACHE_PURGE_BY_APPLICATION Procedure
- 57.5 CACHE_PURGE_BY_PAGE Procedure
- 57.6 CACHE_PURGE_STALE Procedure
- 57.7 CHANGE_CURRENT_USER_PW Procedure
- 57.8 CHANGE_PASSWORD_ON_FIRST_USE Function
- 57.9 CLOB_TO_BLOB Function
- 57.10 CLOSE_OPEN_DB_LINKS Procedure
- 57.11 CLEAR_APP_CACHE Procedure
- 57.12 CLEAR_PAGE_CACHE Procedure
- 57.13 CLEAR_USER_CACHE Procedure
- 57.14 COUNT_CLICK Procedure
- 57.15 CREATE_USER Procedure
- 57.16 CREATE_USER_GROUP Procedure
- 57.17 CURRENT_USER_IN_GROUP Function
- 57.18 CUSTOM_CALENDAR Procedure
- 57.19 DELETE_USER_GROUP Procedure Signature 1
- 57.20 DELETE_USER_GROUP Procedure Signature 2
- 57.21 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
- 57.22 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
- 57.23 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
- 57.24 DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
- 57.25 EDIT_USER Procedure
- 57.26 END_USER_ACCOUNT_DAYS_LEFT Function
- 57.27 EXPIRE_END_USER_ACCOUNT Procedure
- 57.28 EXPIRE_WORKSPACE_ACCOUNT Procedure
- 57.29 EXPORT_USERS Procedure
- 57.30 FEEDBACK_ENABLED Function
- 57.31 FETCH_APP_ITEM Function
- 57.32 FETCH_USER Procedure Signature 1
- 57.33 FETCH_USER Procedure Signature 2
- 57.34 FETCH_USER Procedure Signature 3
- 57.35 FIND_SECURITY_GROUP_ID Function
- 57.36 FIND_WORKSPACE Function
- 57.37 GET_ACCOUNT_LOCKED_STATUS Function
- 57.38 GET_APPLICATION_STATUS Function (Deprecated)
- 57.39 GET_ATTRIBUTE Function
- 57.40 GET_AUTHENTICATION_RESULT Function
- 57.41 GET_BLOB_FILE_SRC Function
- 57.42 GET_BUILD_OPTION_STATUS Function Signature 1 (Deprecated)
- 57.43 GET_BUILD_OPTION_STATUS Function Signature 2 (Deprecated)
- 57.44 GET_CURRENT_USER_ID Function
- 57.45 GET_DEFAULT_SCHEMA Function
- 57.46 GET_EDITION Function
- 57.47 GET_EMAIL Function
- 57.48 GET_FEEDBACK_FOLLOW_UP Function
- 57.49 GET_FILE Procedure
- 57.50 GET_FILE_ID Function
- 57.51 GET_FIRST_NAME Function
- 57.52 GET_GLOBAL_NOTIFICATION Function (Deprecated)
- 57.53 GET_GROUPS_USER_BELONGS_TO Function
- 57.54 GET_GROUP_ID Function
- 57.55 GET_GROUP_NAME Function
- 57.56 GET_HASH Function
- 57.57 GET_HIGH_CONTRAST_MODE_TOGGLE Function
- 57.58 GET_LAST_NAME Function
- 57.59 GET_NUMERIC_SESSION_STATE Function
- 57.60 GET_PREFERENCE Function
- 57.61 GET_PRINT_DOCUMENT Function Signature 1
- 57.62 GET_PRINT_DOCUMENT Function Signature 2
- 57.63 GET_PRINT_DOCUMENT Function Signature 3
- 57.64 GET_PRINT_DOCUMENT Function Signature 4
- 57.65 GET_SCREEN_READER_MODE_TOGGLE Function
- 57.66 GET_SESSION_LANG Function
- 57.67 GET_SESSION_STATE Function
- 57.68 GET_SESSION_TERRITORY Function
- 57.69 GET_SESSION_TIME_ZONE Function
- 57.70 GET_SINCE Function Signature 1
- 57.71 GET_SINCE Function Signature 2
- 57.72 GET_SUPPORTING_OBJECT_SCRIPT Function
- 57.73 GET_SUPPORTING_OBJECT_SCRIPT Procedure
- 57.74 GET_USER_ID Function
- 57.75 GET_USER_ROLES Function
- 57.76 GET_USERNAME Function
- 57.77 HOST_URL Function
- 57.78 HTML_PCT_GRAPH_MASK Function
- 57.79 INCREMENT_CALENDAR Procedure
- 57.80 IR_CLEAR Procedure (Deprecated)
- 57.81 IR_DELETE_REPORT Procedure (Deprecated)
- 57.82 IR_DELETE_SUBSCRIPTION Procedure (Deprecated)
- 57.83 IR_FILTER Procedure (Deprecated)
- 57.84 IR_RESET Procedure (Deprecated)
- 57.85 IS_HIGH_CONTRAST_SESSION Function
- 57.86 IS_HIGH_CONTRAST_SESSION_YN Function
- 57.87 IS_LOGIN_PASSWORD_VALID Function
- 57.88 IS_SCREEN_READER_SESSION Function
- 57.89 IS_SCREEN_READER_SESSION_YN Function
- 57.90 IS_USERNAME_UNIQUE Function
- 57.91 KEYVAL_NUM Function
- 57.92 KEYVAL_VC2 Function
- 57.93 LOCK_ACCOUNT Procedure
- 57.94 PASSWORD_FIRST_USE_OCCURRED Function
- 57.95 PREPARE_URL Function
- 57.96 PRN Procedure
- 57.97 PUBLIC_CHECK_AUTHORIZATION Function (Deprecated)
- 57.98 PURGE_REGIONS_BY_APP Procedure
- 57.99 PURGE_REGIONS_BY_NAME Procedure
- 57.100 PURGE_REGIONS_BY_PAGE Procedure
- 57.101 REDIRECT_URL Procedure
- 57.102 REMOVE_PREFERENCE Procedure
- 57.103 REMOVE_SORT_PREFERENCES Procedure
- 57.104 REMOVE_USER Procedure Signature 1
- 57.105 REMOVE_USER Procedure Signature 2
- 57.106 RESET_AUTHORIZATIONS Procedure (Deprecated)
- 57.107 RESET_PASSWORD Procedure
- 57.108 RESET_PW Procedure
- 57.109 SAVEKEY_NUM Function
- 57.110 SAVEKEY_VC2 Function
- 57.111 SET_APP_BUILD_STATUS Procedure (Deprecated)
- 57.112 SET_APPLICATION_STATUS Procedure (Deprecated)
- 57.113 SET_ATTRIBUTE Procedure
- 57.114 SET_AUTHENTICATION_RESULT Procedure
- 57.115 SET_BUILD_OPTION_STATUS Procedure (Deprecated)
- 57.116 SET_CURRENT_THEME_STYLE Procedure [DEPRECATED]
- 57.117 SET_CUSTOM_AUTH_STATUS Procedure
- 57.118 SET_EDITION Procedure
- 57.119 SET_EMAIL Procedure
- 57.120 SET_FIRST_NAME Procedure
- 57.121 SET_GLOBAL_NOTIFICATION Procedure (Deprecated)
- 57.122 SET_GROUP_GROUP_GRANTS Procedure
- 57.123 SET_GROUP_USER_GRANTS Procedure
- 57.124 SET_LAST_NAME Procedure
- 57.125 SET_PARSING_SCHEMA_FOR _REQUEST Procedure
- 57.126 SET_PREFERENCE Procedure
- 57.127 SET_SECURITY_GROUP_ID Procedure
- 57.128 SET_SESSION_HIGH_CONTRAST_OFF Procedure
- 57.129 SET_SESSION_HIGH_CONTRAST_ON Procedure
- 57.130 SET_SESSION_LANG Procedure
- 57.131 SET_SESSION_LIFETIME_SECONDS Procedure
- 57.132 SET_SESSION_MAX_IDLE_SECONDS Procedure
- 57.133 SET_SESSION_SCREEN_READER_OFF Procedure
- 57.134 SET_SESSION_SCREEN_READER_ON Procedure
- 57.135 SET_SESSION_STATE Procedure
- 57.136 SET_SESSION_TERRITORY Procedure
- 57.137 SET_SESSION_TIME_ZONE Procedure
- 57.138 SET_USERNAME Procedure
- 57.139 SET_WORKSPACE Procedure
- 57.140 SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
- 57.141 SHOW_SCREEN_READER_MODE_TOGGLE Procedure
- 57.142 STRING_TO_TABLE Function (Deprecated)
- 57.143 STRONG_PASSWORD_CHECK Procedure
- 57.144 STRONG_PASSWORD_VALIDATION Function
- 57.145 SUBMIT_FEEDBACK Procedure
- 57.146 SUBMIT_FEEDBACK_FOLLOWUP Procedure
- 57.147 TABLE_TO_STRING Function (Deprecated)
- 57.148 UNEXPIRE_END_USER_ACCOUNT Procedure
- 57.149 UNEXPIRE_WORKSPACE_ACCOUNT Procedure
- 57.150 UNLOCK_ACCOUNT Procedure
- 57.151 URL_ENCODE Function (Deprecated)
- 57.152 WORKSPACE_ACCOUNT_DAYS_LEFT Function
-
58
APEX_WEB_SERVICE
- 58.1 About the APEX_WEB_SERVICE API
- 58.2 About Web Credentials and APEX_WEB_SERVICE
- 58.3 Data Types
- 58.4 Global Variables
- 58.5 APPEND_TO_MULTIPART Procedure Signature 1
- 58.6 APPEND_TO_MULTIPART Procedure Signature 2
- 58.7 BLOB2CLOBBASE64 Function
- 58.8 CLEAR_REQUEST_COOKIES Procedure
- 58.9 CLEAR_REQUEST_HEADERS Procedure
- 58.10 CLOBBASE642BLOB Function
- 58.11 GENERATE_REQUEST_BODY Function
- 58.12 GET_REQUEST_HEADER Function
- 58.13 MAKE_REQUEST Function Signature 1
- 58.14 MAKE_REQUEST Function Signature 2
- 58.15 MAKE_REQUEST Procedure Signature 1
- 58.16 MAKE_REQUEST Procedure Signature 2
- 58.17 MAKE_REST_REQUEST Function
- 58.18 MAKE_REST_REQUEST_B Function
- 58.19 OAUTH_AUTHENTICATE_CREDENTIAL Procedure
- 58.20 OAUTH_AUTHENTICATE Procedure Signature 1
- 58.21 OAUTH_AUTHENTICATE Procedure Signature 2 (Deprecated)
- 58.22 OAUTH_GET_LAST_TOKEN Function
- 58.23 OAUTH_SET_TOKEN Procedure
- 58.24 PARSE_RESPONSE Function
- 58.25 PARSE_RESPONSE_CLOB Function
- 58.26 PARSE_XML Function
- 58.27 PARSE_XML_CLOB Function
- 58.28 REMOVE_REQUEST_HEADER Procedure
- 58.29 SET_REQUEST_ECID_CONTEXT Procedure
- 58.30 SET_REQUEST_HEADERS Procedure
-
59
APEX_WORKFLOW
- 59.1 Constants and Data Types
- 59.2 CONTINUE_ACTIVITY Procedure Signature 1
- 59.3 CONTINUE_ACTIVITY Procedure Signature 2
- 59.4 GET_LOV_ACTIVITY_STATE Function
- 59.5 GET_LOV_WORKFLOW_STATE Function
- 59.6 GET_NEXT_PURGE_TIMESTAMP Function
- 59.7 GET_VARIABLE_CLOB_VALUE Function
- 59.8 GET_VARIABLE_VALUE Function
- 59.9 GET_WORKFLOW_STATE Function
- 59.10 GET_WORKFLOWS Function
- 59.11 IS_ADMIN Function
- 59.12 IS_ALLOWED Function
- 59.13 IS_OF_PARTICIPANT_TYPE Function
- 59.14 REFRESH_PARTICIPANTS Procedure
- 59.15 REMOVE_DEVELOPMENT_INSTANCES Procedure
- 59.16 RESUME Procedure
- 59.17 RETRY Procedure
- 59.18 SET_LOG_LEVEL Procedure
- 59.19 START_WORKFLOW Function
- 59.20 SUSPEND Procedure
- 59.21 TERMINATE Procedure
- 59.22 TERMINATE_FAULTED_WORKFLOWS Procedure
- 59.23 UPDATE_VARIABLES Procedure
- 60 APEX_ZIP
- 61 JavaScript APIs
- Index