title: how to declare date variable in sql using toad for oracle
body: <p>I'm getting a "PLS-00428: an INTO clause is expected in this SELECT statement" when I try to run the following code in sql in TOAD. I need to be able to declare the date variable at the beginning of the code since it will change when I run the report. </p>
  
  <pre><code>declare
  report_date date;
  begin
  report_date := to_date('09/12/2017','mm/dd/yyyy');
    SELECT   IDMOWNER.INDX_WT.ISSUE_NM,
             IDMOWNER.INDX_WT.SEDOL_ID,
             IDMOWNER.INDX_WT.ISSUE_SYM_ID,           
             IDMOWNER.INDX_WT.ISSUE_ID
      FROM   IDMOWNER.INDX_WT
     WHERE   ( ( (IDMOWNER.INDX_WT.RPT_DT) = TO_DATE (report_date, 'mm/dd/yyyy'))
              AND ( (IDMOWNER.INDX_WT.INDX_SRC_CD) = 'SOD')
              AND ( (IDMOWNER.INDX_WT.INDX_SYM_TX) = 'NQSSFB'))
  ORDER BY  IDMOWNER.INDX_WT.RPT_DT,
            IDMOWNER.INDX_WT.ISSUE_SYM_ID,
            IDMOWNER.INDX_WT.MKT_VALUE_AM DESC;      
  end;
  </code></pre>