DECLARE
v_user_name VARCHAR2 (100) := 'NUSER';
v_new_password VARCHAR2 (100) := 'welcome123';
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
DBMS_OUTPUT.put_line (
'Password is changed successfully for the user ' || v_user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while setting new password to the user and the error is '
|| SQLERRM);
END;
v_user_name VARCHAR2 (100) := 'NUSER';
v_new_password VARCHAR2 (100) := 'welcome123';
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
DBMS_OUTPUT.put_line (
'Password is changed successfully for the user ' || v_user_name);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'Error encountered while setting new password to the user and the error is '
|| SQLERRM);
END;
No comments:
Post a Comment