Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help !!! ORA-06530: Reference to uninitialized composite ...
Hi , Please find the main parts of the code :
the declaration part : TYPE char8_array IS TABLE OF CHAR(8)
INDEX BY BINARY_INTEGER; TYPE char12_array IS TABLE OF CHAR(12)
INDEX BY BINARY_INTEGER; TYPE char4_array IS TABLE OF CHAR(4)
INDEX BY BINARY_INTEGER; TYPE char1_array IS TABLE OF CHAR(1)
INDEX BY BINARY_INTEGER; TYPE char10_array IS TABLE OF CHAR(10)
INDEX BY BINARY_INTEGER; TYPE number_array IS TABLE OF NUMBER(10,3)
INDEX BY BINARY_INTEGER; pur_date_arr char8_array;
time_arr char4_array;
pc_arr char4_array;
item_arr char12_array;
shop_arr char10_array;
hhold_arr char10_array;
price_arr number_array;
prc_grp_arr char1_array;
pricedev_arr number_array;
tempprice_arr number_array;
--the part of the body of the package which uses the array elements :
--CUR2 IS A VARIABLE DEFINED AS TYPE OF CURSOR C2. --THERE IS NO PROBLEM
WITH THE CURSOR DECLARATION OR FOR RETRIEVING THE VALUES OF THE CURSOR
FOR CUR2 IN C2 LOOP
m_ctr := m_ctr + 1; pur_date_arr(counter1) := CUR2.DT_PUR_DATE; time_arr(counter1):= CUR2.AC_TIME; hhold_arr(counter1):= CUR2.AC_HHOLD; shop_arr(counter1):= CUR2.AC_SHOP; price_arr(counter1):= CUR2.NC_DATAVALUE; prc_grp_arr(counter1) := CUR2.AC_PRICE_GRP; END --loop for cursor fetch :end
AFTER SOME FETCHES , THE ERROR OCCURS Best Regards Kanchana
--
Posted via dBforums
http://dbforums.com
Received on Sat Mar 16 2002 - 06:09:43 CST