APEX_UTIL

Previous

Next

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

• CLEAR_APP_CACHE Procedure

• CLEAR_PAGE_CACHE Procedure

• CLEAR_USER_CACHE Procedure

• COUNT_CLICK Procedure

• CREATE_USER Procedure

• CREATE_USER_GROUP Procedure

• CURRENT_USER_IN_GROUP Function

• EDIT_USER Procedure

• EXPORT_USERS Procedure

• FETCH_APP_ITEM Function

• FETCH_USER Procedure

• FIND_SECURITY_GROUP_ID Function

• FIND_WORKSPACE Function

• GET_ATTRIBUTE 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_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

• PREPARE_URL Function

• PUBLIC_CHECK_AUTHORIZATION Function

• REMOVE_PREFERENCE Procedure

• REMOVE_SORT_PREFERENCES Procedure

• REMOVE_USER Procedure

• RESET_PW Procedure

• RESET_AUTHORIZATIONS Procedure

• SAVEKEY_NUM Function

• SAVEKEY_VC2 Function

• SET_ATTRIBUTE Procedure

• SET_EMAIL Procedure

• SET_FIRST_NAME Procedure

• SET_LAST_NAME Procedure

• SET_USERNAME Procedure

• SET_PREFERENCE Procedure

• SET_SESSION_STATE Procedure

• STRING_TO_TABLE Function

• TABLE_TO_STRING Function

• URL_ENCODE Function