[kanchana]

Encountering the error message : ORA-06530: Reference to uninitialized composite

-->Package uses table index by binary integer and also the array values are initialized by opening and fetching from a cursor.
There is no pattern for this error and it occurs randomly.

Please suggest.

Thanks
kanchana.

[alligatorsql.com]

Hello kanchana,

can I get the code - please ?

Thanks

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

[alligatorsql.com]

Hello again,

it could be that your programm runs out of process memory.
Could it be, that you get an ORA-04030
ORA-04030: out of process memory when trying to allocate xxxxxxx bytes
after the ORA-06530 ?

I think that makes sense - cause Oracle try to initialise a var - and it needs process memory for that operation ...

Hope this helps.

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

[kanchana]

--the declaration part :GLOBAL TO THE PACKAGE
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

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;
counter1 := counter1 +1 ;
END LOOP;
--loop for cursor fetch :end

AFTER SOME FETCHES , THE ERROR OCCURS

Thanks.

[kanchana]

Originally posted by alligatorsql.com
Hello again,

it could be that your programm runs out of process memory.
Could it be, that you get an ORA-04030
ORA-04030: out of process memory when trying to allocate xxxxxxx bytes
after the ORA-06530 ?

I think that makes sense - cause Oracle try to initialise a var - and it needs process memory for that operation ...

Hope this helps.

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

--------------
No after the ORA-06530 the program terminates and crashes.
There is no other error message reported.