声明动态游标接受,然后放入集合使用 DECLARE s SYS_REFCURSOR; TYPE t IS TABLE OF test_fan%ROWTYPE; t1 t; BEGIN DECLARE PROCEDURE test1(o_cursor OUT SYS_REFCURSOR) IS BEGIN OPEN o_cursor FOR SELECT * FROM test_fan; END; BEGIN test1(o_cursor => s); FETCH s BULK COLLECT INTO t1; FOR i IN 1 .. t1.count LOOP dbms_output.put_line(t1(i).object_name); END LOOP; CLOSE s; END; END; 不知道是否是你想要的
https://www.jb51.net/article/32447.htm
DECLARE
s SYS_REFCURSOR;
TYPE t IS TABLE OF test_fan%ROWTYPE;
t1 t;
BEGIN
DECLARE
PROCEDURE test1(o_cursor OUT SYS_REFCURSOR) IS
BEGIN
OPEN o_cursor FOR
SELECT * FROM test_fan;
END;
BEGIN
test1(o_cursor => s);
FETCH s BULK COLLECT
INTO t1;
FOR i IN 1 .. t1.count LOOP
dbms_output.put_line(t1(i).object_name);
END LOOP;
CLOSE s;
END;
END;
不知道是否是你想要的