存储过程问题，请高手看看是什么情况？
有这么一个练习题：
创建存储过程，输入员工薪水范围，返回员工工号、姓名、薪水结果集，结果集按员工薪水升序排列？
create or replace
procedure pro_emp(v_sal1 number,v_sal2 number)
as
v_id number;
v_name varchar2(30);
v_salary number;
cursor cur_emp is
select e.empno,e.ename,e.sal from emp e where e.sal between v_sal1 and v_sal2 order by e.sal;
begin
open cur_emp;
loop
fetch cur_emp into v_id, v_salary,v_name;
dbms_output.put_line(v_id||' '||v_salary||' '||v_name);
exit when cur_emp %notfound;
end loop;
end;
