title: PL/SQL - Query returns more than one ROW
body: <p>I'm using plsql to perform return a group of records and then update this records based on the results.. I'm getting stuck...</p>
  
  <p>As my SELECT statements is returnning more than 1 ROW. So how do I go about returning all rows into a VARIABLE.. As I keep getting the following ERROR : PL/SQL: ORA-00947: not enough values</p>
  
  <p>Attached is snippett of code.</p>
  
  <pre><code>BEGIN
  
  -- Set Variables
  
  v_ArchivedDate := '01-JAN-14'; -- Enter Variable
  v_Results := '0';
  
  -- This get current date/time minus 31 days ago
  SELECT TO_CHAR(systimestamp-31, 'DD-MON-YY HH.MI.SS') INTO v_ArchivedDate 
  FROM dual;
  
  
  dbms_output.put_line('Date to Set Archived_At Column :' || ' ' || v_ArchivedDate); 
  </code></pre>
  
  <p>This is where the script seems to be failing with the above ERROR</p>
  
  <pre><code>          SELECT * INTO v_results
            FROM message
            WHERE from_entity IN
            (SELECT entity_id FROM user_info
            WHERE UPPER(directory_auth_id) = 'USER100');
  </code></pre>
  
  <p>I'm a novice at plsql, so on a learning curve at the mo..</p>
  
  <p>So do I need to select into some sort of GROUPSET / ARRAY etc.. not sure.</p>
  
  <p>Thanks  for looking.
  Boardman              </p>