Ref Cursor Example

DECLARE

OUT_REF SYS_REFCURSOR;

L_TEST VARCHAR2(22);

BEGIN

    OPEN OUT_REF FOR

SELECT  'Testing' FROM DUAL;

    LOOP

        FETCH OUT_REF

        INTO  L_TEST;

        EXIT WHEN OUT_REF%NOTFOUND;

    DBMS_OUTPUT.PUT_LINE('TEST:'|| L_TEST);

END LOOP;

END;