Oracle 存储函数返回一个游标,如何取值,初学求教

2025-05-17 19:14:25
推荐回答(1个)
回答1:

代码:
CREATE OR REPLACE PROCEDURE P_TESTB
AS

VARCURSOR SYS_REFCURSOR;
R USERS%ROWTYPE;
BEGIN

P_TESTA(VARCURSOR);
LOOP
FETCH VARCURSOR INTO R;
EXIT WHEN
VARCURSOR%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(R.NAME);
END LOOP;
END
P_TESTB;