create or replace procedure pro_1(sum0 number,rote0 number) is
cursor cur_1 is select * from emp_sal order by sal for update of sal;
sum1 number;
sum number;
rote number;
begin
sum:=sum0;
rote:=rote0;
for i in cur_1 loop
select sum(sal) into sum1 from emp_sal;
if (sum1+i.sal+i.sal*rote) > sum then
exit;
end if;
sum:=sum1+i.sal*(1+rote);
update emp_sal set sal=sal*(1+rote) where current of cur_1;
end loop;
end;
/
