17,382
社区成员




----------------------------------------------------------------------------
--
-- ChangePassword (PUBLIC)
-- Set new password for a given user without having to provide
-- the old password.
--
-- Usage example in pl/sql
-- begin fnd_user_pkg.changepassword('SCOTT', 'WELCOME'); end;
--
-- Input (Mandatory)
-- username: User Name
-- newpassword New Password
--
function ChangePassword(username varchar2,
newpassword varchar2) return boolean;
----------------------------------------------------------------------------
--
-- ChangePassword (PUBLIC)
-- Set new password for a given user if the existing password needed to be
-- validated before changing to the new password.
--
-- Usage example in pl/sql
-- begin fnd_user_pkg.changepassword('SCOTT', 'TIGER', 'WELCOME'); end;
--
-- Input (Mandatory)
-- username: User Name
-- oldpassword Old Password
-- newpassword New Password
--
function ChangePassword(username varchar2,
oldpassword varchar2,
newpassword varchar2) return boolean;