存储过程输出复杂动态sql结果集

DECLARE
	S1 STRING
	S2 STRING
	S3 STRING
	DATA_DATE DATE := '2020-01-27'
	CURSOR CUR(S DATE) IS SELECT CARD_NO AS S1, CUST_NO AS S2,DATA_DATE AS S3 FROM XXX WHERE DATA_DATE = S LIMIT 2
BEGIN
	LOOP
		DATA_DATE := DATA_DATE + 1
		OPEN CUR(TO_CHAR(DATA_DATE,'YYYY-MM-DD'))
		LOOP
			FETCH CUR INTO S1,S2,S3
			
			EXIT WHEN CUR%NOTFOUND
			DBMS_OUTPUT.PUT_LINE(S1 || ',' || S2 || ',' || S3)
		END LOOP;
		CLOSE CUR
	EXIT WHEN DATA_DATE = '2020-01-31'
	END LOOP
END