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;
原文地址:https://www.cnblogs.com/xh_Blog/p/11281449.html