DataFound := ''; -- 변수
OPEN C_RESERVE_EXAM;
LOOP
FETCH C_RESERVE_EXAM into tRESERVE_DATE, tDESTINATION_NAME ;
EXIT WHEN C_RESERVE_EXAM%NOTFOUND;
DataFound := DataFound || tRESERVE_DATE || ' ' || tDESTINATION_NAME ;
END LOOP;
CLOSE C_RESERVE_EXAM;
Return DataFound; |