1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
SET SERVEROUTPUT ON
DECLARE
v_success BOOLEAN;
BEGIN
v_success := fnd_user_pkg.ChangePassword(
username => 'SYSADMIN',
newpassword => 'P@ssW0rd'
);
IF v_success THEN
DBMS_OUTPUT.PUT_LINE('Change Success!');
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('Change Fail!');
ROLLBACK;
END IF;
END;
/
|
