Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help !!! ORA-06530: Reference to uninitialized composite ...

Re: Please help !!! ORA-06530: Reference to uninitialized composite ...

From: kanchana <member_at_dbforums.com>
Date: 16 Mar 2002 06:09:43 -0600
Message-ID: <3c933607_1@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 - 06:09:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US