ORA 1002. Fetch Out of sequence error

All the variables are properly declared. I am getting Fetch out of sequence error ORA-01002 where I marked with ----> in the code below. The cursor declaration is in the beginning o fthe program.

                cursor c2_get_tests is
                select substr(description_text,1,15), result
                from descriptions_at_dmscprod a, sap_test_results_at_dmscprod b
                where language_code = 'E'
                and table_name = 'TESTS'
                and b.control_number = lc_ctrl_num
                and b.test_code||b.center_code = a.ukey;
                c2_get_tests_rec c2_get_tests%ROWTYPE;
                 ....
                 ....
                 ....
                open c2_get_tests;
                loop


 ----->             fetch c2_get_tests into lc_test_name, lc_results;


                    exit when c2_get_tests%NOTFOUND;
                    rec1 :='BXXSEAN'|| lc_ctrl_num ||lc_test_name;
                    insert_to_tmp;
                end loop; /* c2_get_tests */
                close c2_get_tests;

Thanks
Mike

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 09:39:39 CST