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;

 

posted @ 2019-08-01 11:29  xh_Blog  阅读(416)  评论(0编辑  收藏  举报