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

Question

5.写一个存储过程  输入: 部门编号  查出该部门的人,工资比ADAMS高,则提成增加100, 比ADAMS低,则提成增加200  显示提成增加后的员工信息create or replace procedure a_sc(i_deptno number)iscursor 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;