Home > APEX_UTIL

APEX_UTIL

The APEX_UTIL package provides utilities you can use when programming in the Oracle Application Express environment. You can use the APEX_UTIL package to get and set session state, get files, check authorizations for users, reset different states for users, and also to get and set preferences for users.

Topics:

• CHANGE_CURRENT_USER_PW Procedure

• CACHE_GET_DATE_OF_PAGE_CACHE Procedure

• CACHE_GET_DATE_OF_REGION_CACHE Procedure

• CACHE_PURGE_BY_APPLICATION Procedure

• CACHE_PURGE_BY_PAGE Procedure

• CACHE_PURGE_STALE Procedure

• CHANGE_PASSWORD_ON_FIRST_USE Function

• CLEAR_APP_CACHE Procedure

• CLEAR_PAGE_CACHE Procedure

• CLEAR_USER_CACHE Procedure

• COUNT_CLICK Procedure

• COUNT_STALE_REGIONS Function

• CREATE_USER Procedure

• CREATE_USER_GROUP Procedure

• CURRENT_USER_IN_GROUP Function

• EDIT_USER Procedure

• EXPIRE_END_USER_ACCOUNT Procedure

• EXPIRE_WORKSPACE_ACCOUNT Procedure

• EXPORT_USERS Procedure

• FETCH_APP_ITEM Function

• FETCH_USER Procedure

• FIND_SECURITY_GROUP_ID Function

• FIND_WORKSPACE Function

• GET_ACCOUNT_LOCKED_STATUS Function

• GET_ATTRIBUTE Function

• GET_AUTHENTICATION_RESULT Function

• GET_BLOB_FILE_SRC Function

• GET_CURRENT_USER_ID Function

• GET_DEFAULT_SCHEMA Function

• GET_EMAIL Function

• GET_FILE Procedure

• GET_FILE_ID Function

• GET_FIRST_NAME Function

• GET_GROUPS_USER_BELONGS_TO Function

• GET_GROUP_ID Function

• GET_GROUP_NAME Function

• GET_LAST_NAME Function

• GET_USERNAME Function

• GET_NUMERIC_SESSION_STATE Function

• GET_PREFERENCE Function

• GET_PRINT_DOCUMENT Function

• GET_PRINT_DOCUMENT Function

• GET_PRINT_DOCUMENT Function

• GET_PRINT_DOCUMENT Function

• DOWNLOAD_PRINT_DOCUMENT Procedure

• DOWNLOAD_PRINT_DOCUMENT Procedure

• DOWNLOAD_PRINT_DOCUMENT Procedure

• DOWNLOAD_PRINT_DOCUMENT Procedure

• GET_SESSION_STATE Function

• GET_USER_ID Function

• GET_USER_ROLES Function

• IS_LOGIN_PASSWORD_VALID Function

• IS_USERNAME_UNIQUE Function

• KEYVAL_NUM Function

• KEYVAL_VC2 Function

• LOCK_ACCOUNT Procedure

• PASSWORD_FIRST_USE_OCCURRED Function

• PREPARE_URL Function

• PUBLIC_CHECK_AUTHORIZATION Function

• PURGE_REGIONS_BY_APP Procedure

• PURGE_REGIONS_BY_ID Procedure

• PURGE_REGIONS_BY_NAME Procedure

• PURGE_REGIONS_BY_PAGE Procedure

• PURGE_STALE_REGIONS Procedure

• REMOVE_PREFERENCE Procedure

• REMOVE_SORT_PREFERENCES Procedure

• REMOVE_USER Procedure

• RESET_AUTHORIZATIONS Procedure

• RESET_PW Procedure

• SAVEKEY_NUM Function

• SAVEKEY_VC2 Function

• SET_ATTRIBUTE Procedure

• SET_AUTHENTICATION_RESULT Procedure

• SET_CUSTOM_AUTH_STATUS Procedure

• SET_EMAIL Procedure

• SET_FIRST_NAME Procedure

• SET_LAST_NAME Procedure

• SET_PREFERENCE Procedure

• SET_SESSION_STATE Procedure

• SET_USERNAME Procedure

• STRONG_PASSWORD_CHECK Procedure

• STRONG_PASSWORD_VALIDATIONFunction

• STRING_TO_TABLE Function

• TABLE_TO_STRING Function

• UNEXPIRE_END_USER_ACCOUNT Procedure

• UNEXPIRE_WORKSPACE_ACCOUNT Procedure

• UNLOCK_ACCOUNT Procedure

• URL_ENCODE Function

• WORKSPACE_ACCOUNT_DAYS_LEFT Function

Copyright © 2003, 2008, Oracle. All rights reserved.

Previous

Next