Hi,

I created a procedure which would copy all of the information from table_a to table_b for a new user. This procedure should also copy the information from table_a to table_b after a new user has been created. However I don't know why it does not seem to do so. Below is the procedure. I'll appreciate any input.


CREATE OR REPLACE PROCEDURE newuser (
a_username VARCHAR2
)
IS
BEGIN
UPDATE table_a
SET last_login=TO_DATE('1/1/2006','MM/DD/YYYY')
WHERE username=a_username;
COMMIT;

UPDATE table_b
SET last_login=TO_DATE('1/1/2006','MM/DD/YYYY')
WHERE username=a_username;
commit;
END;
/



Thanks,

Lucky