Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    Posts
    3

    Post Unanswered: ORA-06530 :Reference to uninitialised composite

    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.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello kanchana,

    can I get the code - please ?

    Thanks

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

  3. #3
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    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

  4. #4
    Join Date
    Mar 2002
    Posts
    3
    --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.

  5. #5
    Join Date
    Mar 2002
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •