17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure usp_getset
(
acs_results out sys_refcursor
)
as
begin
open acs_results for
select * from employees;
end usp_getset;
declare
cs_results sys_refcursor;
begin
usp_getset(cs_results);
for test in cs_results loop
dbms_output.put_line(test.employee_id);
end loop;
end;
DECLARE
cs_results sys_refcursor;
employees_row employees%ROWTYPE;
BEGIN
usp_getset (cs_results);
LOOP
FETCH cs_results
INTO employees_row;
EXIT WHEN cs_results%NOTFOUND;
DBMS_OUTPUT.put_line (employees_row.employee_id);
END LOOP;
close cs_results;
END;
declare
cs_results sys_refcursor;
r_employees employees%rowtype;
begin
usp_getset(cs_results);
loop
fetch cs_results into r_employees;
exit when cs_results%not_found;
dbms_output.put_line(r_employees.employee_id);
end loop;
end;