Update Stored Procedure - Oracle 10g

PROCEDURE CHANGE_PASSWORD
(
PASSWORD_IN VARCHAR2,
USERNAME_IN VARCHAR2,
RES OUT INT

)
 IS


BEGIN
  
UPDATE TIMUSER SET PASSWORD = PASSWORD_IN, PASSWORDSET_DATE = SYSDATE  WHERE lower(USERNAME)=lower(USERNAME_IN);
RES := 1;
COMMIT;

END CHANGE_PASSWORD;