You are using the counter1 variable which I dont see initialized anywhere
(may be you have snipped that part of the code)
anyway you can catch it using the pre-defined exception ACCESS_INTO_NULL
like
EXCEPTION WHEN ACCESS_INTO_NULL THEN
HTH
"kanchana" <member_at_dbforums.com> wrote in message
news:3c933607_1_at_spamkiller.newsgroups.com...
> 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 - 11:00:17 CST
