title: Oracle PL/SQL - Bulk Collection usage into WHERE and FROM clause inside conditions and inner views
body: <p>I have a strange problem using bulk collection as element of FROM clause. 
  When I execute this code example, I get, just at run-time, the error "invalid table name". </p>
  
  <p>If I replace the collection with a table everything works well.</p>
  
  <p>Is there any restriction about bulk collection that I'm missing? 
  Maybe I cannot use anonymous block in FROM clause?
  In the sql debugger I see that l_vol(i) has values but l_vol(i).FIELD doesn't exists.</p>
  
  <p>Thanks.</p>
  
  <pre><code> TYPE t_bulk_vol is table of vol%ROWTYPE;
   l_vol t_bulk_vol;
   ...
   cursor cur is SELECT * FROM vol where ... ;
  
   OPEN CUR;
   LOOP 
       FETCH CUR BULK COLLECT INTO l_vol;
       ....
       insert into dest
       select col1, col2, ... from 
       (inner view with some pivot, unpivot and l_vol(i).FIELD ...) src where l_vol(i).FIELD = src.FIELD;
  </code></pre>
  
  <p>PS: I cannot paste original code.</p>