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;
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;