下面这个测试不出来结果,但是存储过程写对了. 哪位大神帮忙看下

Question

5.写一个存储过程
  输入: 部门编号
  查出该部门的人,工资比ADAMS高,则提成增加100, 比ADAMS低,则提成增加200
  显示提成增加后的员工信息
create or replace procedure a_sc(i_deptno number)
is
cursor c_emp is select * from emp where deptno=i_deptno;
l_sal number;
a_sal number;
l_commnew number;
begin
  select sal into l_sal from emp where deptno=i_deptno;
  select sal into a_sal from emp where deptno=i_deptno and ename='ADAMS';
  if l_sal > a_sal then
    update emp2 set comm=comm+100 where deptno=i_deptno
    returning comm into l_commnew;
    else
      update emp2 set comm=comm+200 where deptno=i_deptno
      returning comm into l_commnew;
   end if;
   for v_emp in c_emp loop
     dbms_output.put_line('姓名:'||v_emp.ename);
     end loop;
end;