title: an INTO clause is expected in this SELECT statement when working with PLSQL
body: <p>I am getting the following error. Getting the error at <code>SELECT CASE</code> statement.</p>
  
  <blockquote>
    <p>PLS-00428: an INTO clause is expected in this SELECT statement</p>
  </blockquote>
  
  <pre><code>FOR REMS IN cur_names LOOP
  
  SELECT CASE   
          WHEN EXISTS (SELECT 1 
                       FROM SupplyTable 
                       WHERE FirstName = REMS.Names) 
          THEN 'Y' 
          ELSE 'N' 
      END AS rec_exists
  FROM dual;
  
    IF rec_exists = 'Y' THEN
      FName := REMS.Names;
    ELSE
      FName := 'Gen';
    END IF;
  END LOOP;
  </code></pre>