regarding fetch across commits
is the following valide? is it good?
if it is not, what's other choice?

declare
cursor tab_row is select name,num_years_worked from names;
my_row tab_row%rowtype;
begin
for my_row in tab_row loop
if my_row.num_years_worked>5 then
update names set eligible_for_award='Y' where current of tab_row;
commit;
end if;
end loop;
end;