oracle存储过程返回游标一

1.存储过程

CREATE OR REPLACE PROCEDURE TEST_PC(CUR_RESULT OUT SYS_REFCURSOR) ISBEGIN  OPEN CUR_RESULT FOR    SELECT LEVEL + SYSDATE THEDAY FROM DUAL CONNECT BY LEVEL < 6;END TEST_PC;

2.测试代码

DECLARE  CUR_CALLING SYS_REFCURSOR;  THEDAY      DATE;BEGIN  TEST_PC(CUR_CALLING);  LOOP    FETCH CUR_CALLING      INTO THEDAY;    EXIT WHEN CUR_CALLING%NOTFOUND;    DBMS_OUTPUT.PUT_LINE(THEDAY);  END LOOP;END;