title: How to store multiple rows in a variable in pl/sql function?
body: <p>I'm writing a pl/sql function. I need to select multiple rows from select statement:</p>
  
  <pre><code>    SELECT pel.ceid
      FROM pa_exception_list pel
      WHERE trunc(pel.creation_date) &gt;= trunc(SYSDATE-7)
  </code></pre>
  
  <p>if i use:</p>
  
  <pre><code>SELECT pel.ceid
  INTO v_ceid
  </code></pre>
  
  <p>it only stores one value, but i need to store all values that this select returns. Given that this is a function i can't just use simple <strong>select</strong> because i get error, "<strong>INTO</strong> - is expected." </p>