title: ORA-06532: Subscript outside of limit error
body: <p>I am getting a ORA-06532 error in my pl/sql procedure.  It has to do with my array, and it seems to be happening on the line that starts: "term_1 := ...".  The query that selects into gets 7 records, so it should be the same amount as what I am calling for.  I am a little new to the SQL array thing, so I may have missed something obvious.  Any help is appreciated, thanks.</p>
  
  <pre><code>DECLARE
  
  listOfTerms      VC50_ARRAY;
  term_1           varchar2(30);
  term_2           varchar2(30);
  term_3           varchar2(30);
  term_4           varchar2(30);
  term_5           varchar2(30);
  term_6           varchar2(30);
  term_7           varchar2(30);
  
  BEGIN
  
  SELECT apl.awdp_acad_terms 
  BULK COLLECT INTO listOfTerms
  FROM fa_years fay 
     JOIN award_periods_ls apl
       ON apl.award_periods_id = fay.award_periods_id 
  WHERE (SELECT b.awdp_fa_year as faYear 
        FROM award_periods_ls a 
             JOIN coll18_test.fa_years b ON a.award_periods_id = b.award_periods_id 
       WHERE awdp_acad_terms = v_ug_term) = fay.awdp_fa_year
  ORDER BY apl.awdp_acad_terms DESC;
  
  term_1   := listOFTerms(1);     
  term_2   := listOFTerms(2);             
  term_3   := listOFTerms(3);
  term_4   := listOFTerms(4);             
  term_5   := listOFTerms(5);             
  term_6   := listOFTerms(6);             
  term_7   := listOFTerms(7);   
  </code></pre>