oracle未查找到任何数据问题
如下:
V_V_COUNT NUMBER;为定义的变量;
/*客户分析*/ SELECT COUNT(*) INTO V_V_COUNT FROM PROJ_REPORT_INFO WHERE PROJID = V_P_PROJID AND REPORTTYPE = 'FIRST_REPORT'; IF (V_V_COUNT > 0) THEN SELECT REPORTID INTO V_REPORTID FROM PROJ_REPORT_INFO WHERE PROJID = V_P_PROJID AND REPORTTYPE = 'FIRST_REPORT'; END IF;