title: Using variables in PLSQL SELECT statement
body: <p>I have a query that queries on ReportStartDate and ReportEndDate so I thought I would use variables in PLSQL. Not sure what I am missing here, but I get an error:</p>
  
  <pre><code>CLEAR;
  DECLARE
      varReportStartDate Date := to_date('05/01/2010', 'mm/dd/yyyy');
      varReportEndDate Date := to_date('05/31/2010', 'mm/dd/yyyy');
  BEGIN
  
      SELECT 
            'Value TYPE', 
            1 AS CountType1, 
            2 AS CountType2, 
            3 AS CountType3 
      FROM DUAL;
  
      SELECT COUNT (*) 
      FROM CDR.MSRS_E_INADVCH
  
      WHERE 1=1
      AND ReportStartDate = varReportStartDate 
      AND ReportEndDate = varReportEndDate 
      ;
  END;
  /
  </code></pre>
  
  <p>The Error is:</p>
  
  <pre><code>Error starting at line 2 in command:
  Error report:
  ORA-06550: line 6, column 5:
  PLS-00428: an INTO clause is expected in this SELECT statement
  ORA-06550: line 8, column 5:
  PLS-00428: an INTO clause is expected in this SELECT statement
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:
  </code></pre>
  
  <p>This happens in Toad as well as in SQL Developer.</p>
  
  <p>What is the proper way of using the variables in my WHERE clause?</p>