title: Oracle: Bulk collect into "table of number" gives "numeric or value error"
body: <p>I've come across an example of doing this on the net which also fails on my DB (10g) but here's my version.</p>
  
  <pre><code>...
  TYPE prog_rec_type IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
  
  prog_rec_list prog_rec_type;
  
  begin
  
  ...
  
  EXECUTE IMMEDIATE 'SELECT PROGRESS_RECID FROM ' || v_table_name || v_where BULK COLLECT INTO prog_rec_list;
  
  
  --ERROR FOUND IN THIS SECTION
  FOR i IN prog_rec_list.FIRST..prog_rec_list.LAST
  LOOP
  
  
  --DBMS_OUTPUT.PUT_LINE('FOR LOOP: ' || i);
  
  null;
  
  END LOOP;
  
  ...
  END;
  </code></pre>
  
  <p>Much appreciate the help.</p>