UPDATE and commit;

[Subha]

create or replace PROCEDURE update_testing is
cursor c1 is select a.EMP_ID val_id from LOCATION A ,TEST B WHERE a.REL_DIRECTORY=b.REL_DIRECTORY;
my_counter number(12);
begin
my_counter:=0;
for c2 in c1 loop
UPDATE TEST SET EMP_ID=C2.VAL_ID;
my_counter:=my_counter+1;
if my_counter=50000 then
commit;
my_counter:=0 ;
end if;
COMMIT;
end loop;
end;

This procedure when executed does not not commit after every 50000 records and the procedure fails because of rollback segs ... What is wrong in the procedure ..