Help . Fetch Out of sequence error in PL/SQL
From: <m_popov_at_hotmail.com>
Date: Wed, 24 Feb 1999 15:38:34 GMT
Message-ID: <7b16dp$p0f$1_at_nnrp1.dejanews.com>
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.
Date: Wed, 24 Feb 1999 15:38:34 GMT
Message-ID: <7b16dp$p0f$1_at_nnrp1.dejanews.com>
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 - 16:38:34 CET