返回结果集的存储过程 及调用sys_refcursor--结果集

create or replace procedure emp_demo5(empsalary out sys_refcursor) AS ---结果集oracl带
begin
  OPEN empsalary FOR
  SELECT s.employeeid,s.salaryvalue from salary s;
end emp_demo5;

DECLARE
  employeeid salary.employeeid%TYPE;--员工编号
  salaryvalue salary.salaryvalue%TYPE;--员工薪水
  emp_salary SYS_REFCURSOR;--结果集
BEGIN
  emp_demo5(emp_salary);
  LOOP
    FETCH emp_salary INTO employeeid,salaryvalue;
    EXIT WHEN emp_salary %NOTFOUND;
    dbms_output.put_line(employeeid||' '||salaryvalue);
  END LOOP;
  CLOSE emp_salary;
END;