title: How to initialize a varray table of {TABLE}%ROWTYPE?
body: <p>I have a varray defined like:</p>
  
  <pre><code>declare
      TYPE tnr_l IS VARRAY(30) of lve%ROWTYPE;
  </code></pre>
  
  <p>I want this varray to be initialized with a fetch from the database:</p>
  
  <pre><code>select * into tnr_l from lve where type = 'TNR' order by value;
  </code></pre>
  
  <p>But this fails with:</p>
  
  <pre><code>.ORA-06550: line 6, column 23:
  PLS-00321: expression 'TNR_L' is inappropriate as the left hand side of an
  assignment statement
  </code></pre>
  
  <p>How can I make this work?</p>