add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, June 21

Reset the Oracle Apps user PWD Query

BEGIN
IF fnd_user_pkg.changepassword ('&uname', '&pswd')
THEN
DBMS_OUTPUT.put_line ('Password changed successfully');
ELSE
DBMS_OUTPUT.put_line ('Failed changing password');
END IF;
commit;
END;

No comments: