This procedure changes the password of the currently authenticated user, assuming Application Express user accounts are in use.
APEX_UTIL.CHANGE_CURRENT_USER_PW( p_new_password IN VARCHAR2);
Table 28-6 CHANGE_CURRENT_USER_PW Parameters
The new password value in clear text.
The following example demonstrates how to use the
CHANGE_CURRENT_USER_PW procedure to change the password for the user who is currently authenticated, assuming Application Express accounts are in use.
BEGIN APEX_UTIL.CHANGE_CURRENT_USER_PW ('secret99'); END;