DECLARE
v_user_name VARCHAR2 (30) := UPPER ('A1199024');
v_new_password VARCHAR2 (30) := 'welcome2airtel';
v_status BOOLEAN;
BEGIN
v_status :=
fnd_user_pkg.changepassword (username => v_user_name,
newpassword => v_new_password
);
IF v_status = TRUE
THEN
DBMS_OUTPUT.put_line
( 'The password reset successfully for the User:'
|| v_user_name
);
COMMIT;
ELSE
DBMS_OUTPUT.put_line ( 'Unable to reset password due to'
|| SQLCODE
|| ' '
|| SUBSTR (SQLERRM, 1, 100)
);
ROLLBACK;
END IF;
END;
v_user_name VARCHAR2 (30) := UPPER ('A1199024');
v_new_password VARCHAR2 (30) := 'welcome2airtel';
v_status BOOLEAN;
BEGIN
v_status :=
fnd_user_pkg.changepassword (username => v_user_name,
newpassword => v_new_password
);
IF v_status = TRUE
THEN
DBMS_OUTPUT.put_line
( 'The password reset successfully for the User:'
|| v_user_name
);
COMMIT;
ELSE
DBMS_OUTPUT.put_line ( 'Unable to reset password due to'
|| SQLCODE
|| ' '
|| SUBSTR (SQLERRM, 1, 100)
);
ROLLBACK;
END IF;
END;
No comments:
Post a Comment