存储过程 oracle 打印,oracle – PL/SQL打印出由存储过程返回的参考游标

如何从存储过程返回的引用游标(OUT变量)中获取并将结果行打印到sql * PLUS中的STDOUT？

ORACLE存储过程：

PROCEDURE GetGrantListByPI(p_firstname IN VARCHAR2,p_lastname IN VARCHAR2,p_orderby IN VARCHAR2,p_cursor OUT grantcur);

PL / sql：

SET SERVEROUTPUT ON;

DECLARE

TYPE r_cursor IS REF CURSOR;

refCursor r_cursor;

CURSOR grantCursor IS

SELECT last_name,first_name

FROM ten_year_pis

WHERE year_added = 2010;

last_name VARCHAR2(100);

first_name VARCHAR2(100);

BEGIN

OPEN grantCursor;

FETCH grantCursor INTO last_name,first_name;

WHILE grantCursor%FOUND LOOP

PMAWEB_PKG.GetGrantListByPI(last_name,first_name,'last_name',refCursor);

--HOW DO I LOOP THROUGH THE RETURNED REF CURSOR (refCursor)

--AND PRINT THE RESULTING ROWS TO STDOUT?

FETCH grantCursor into last_name,first_name;

END LOOP;

CLOSE grantCursor;

END;

/