How to initialize az OBJECT type Variable

From: Andor Gyula <gy.andor_at_euromacc.hu>
Date: Thu, 01 Feb 2001 06:12:44 -0800
Message-ID: <F001.002A72AE.20010201054614@fatcity.com>

Hi Gurus !

My problem is, that I have a varray(100) of T_OBJ and I can't put values into it.

T_OBJ is OBJECT (ID NUM, NAME Varchar2(50));

Procedure Test is
TYPE T_VARRAY is VARRAY(100) of t_obj;
V_VARRAY T_VARRAY;
Begin

    V_VARRAY :=T_VARRAY();
    V_VARRAY.EXTEND;
    I: =V_VARRAY.FIRST;
    V_VARRAY(I).ID:=1;
End;

This gives ORA-06530: Reference to uninitialized composite.

What's wrong?

Gyula

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andor Gyula
INET: gy.andor_at_euromacc.hu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 01 2001 - 08:12:44 CST