ORACLE 参照变量(ref cursor)
DECLARE
TYPE C1 IS REF CURSOR;
V_CURSOR C1;
V_NAME T_TABLE.NAME%TYPE;
V_DESC T_TABLE.DESCRIPTION %TYPE;
BEGIN
OPEN V_CURSOR FOR
SELECT NAME,DESCRIPTION FROM T_TABLE;
FETCH V_CURSOR INTO V_NAME,V_DESC;
EXIT WHEN V_CURSOR%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(V_NAME ||'--------'|| V_DESC);
END