-
Procedure to update table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|