DECLARE
l_ret_val BOOLEAN;
l_user_name varchar2(50) := 'RAJKUMARMA';
l_new_pwd varchar2(20) := 'oracle120';
BEGIN
l_ret_val :=
fnd_user_pkg.changepassword(username=> l_user_name
,newpassword => l_new_pwd);
IF l_ret_val
THEN
DBMS_OUTPUT.PUT_LINE('The password is successfully reset to '|| l_new_pwd);
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('The password reset has failed');
END IF;
END;
l_ret_val BOOLEAN;
l_user_name varchar2(50) := 'RAJKUMARMA';
l_new_pwd varchar2(20) := 'oracle120';
BEGIN
l_ret_val :=
fnd_user_pkg.changepassword(username=> l_user_name
,newpassword => l_new_pwd);
IF l_ret_val
THEN
DBMS_OUTPUT.PUT_LINE('The password is successfully reset to '|| l_new_pwd);
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('The password reset has failed');
END IF;
END;
No comments:
Post a Comment