cursor c_emp is select job,empno,ename from emp for update;

c_manager constant number :=0.30;

c_salesman constant number :=0.4;

v_job varchar(100);

v_empno varchar(100);

v_ename varchar(100);

v_ratio number(7,2);

begin

open c_emp;

loop

fetch c_emp

into v_job, v_empno,v_ename;

exit when c_emp%notfound;

v_ratio :=getaddsalaryratio(v_job);

if v_job='MANAGER'

then update emp set sal=sal*(1+v_ratio)

where current of c_emp;

elsif v_job='SALESMAN'

then update emp set sal=sal*(1+v_ratio)

where current of c_emp;

end if;

dbms_output.put_line('为员工'||v_empno||'成功加薪');

end loop;

close c_emp;

exception

when no_data_found

then

dbms_output.put_line('没有找到数据');