网上看了一些例子,确实是存储过程少返回结果集,现在已经解决了,谢谢各位。我是这样改的CREATE OR REPLACE PROCEDURE SP_MV_GWZBFX_FQ(V_YEAR IN VARCHAR2, ...
显示全部网上看了一些例子,确实是存储过程少返回结果集,现在已经解决了,谢谢各位。
我是这样改的
CREATE OR REPLACE PROCEDURE SP_MV_GWZBFX_FQ(V_YEAR IN VARCHAR2,
V_RESULT OUT SYS_REFCURSOR) IS
V_SQL VARCHAR2(20000);
BEGIN
V_SQL := 'SELECT STATISTICDATE, MONTHCODE, MONTHNAME, QUARTERCODE, QUARTERNAME, YEARCODE, YEARNAME,
COMCODE, COMNAME, COMCODE1, COMNAME1, COMCODE2, COMNAME2, GRADECODE, GRADENAME, USERCODE, USERNAME,
VERSIONID, IMPMEANSNAME, TYPE, TYPENAME, STARTDATE, ENDDATE, STATUS, STATUSNAME, STINDEXCODE,
INDEXNAME, SCORE, ASSESSTYPE FROM MV_GWZBFX_FQ PARTITION(P' || V_YEAR || ')';
OPEN V_RESULT FOR V_SQL;
END SP_MV_GWZBFX_FQ;
收起