Re: Accessing components of an object within a varray...

william_hulse_at_hotmail.com (will) writes:

> Hope you can help with the following...
>
> I have the following type declaration
>
> CREATE OR REPLACE TYPE mytype IS OBJECT (
> STATUS VARCHAR2(1000),
> SET_OF_BOOKS_ID NUMBER,
> ACCOUNTING_DATE DATE,
> CURRENCY_CODE VARCHAR2(1000),
> DATE_CREATED DATE,
> CREATED_BY NUMBER,
>
> );
>
> CREATE OR REPLACE TYPE mytype_Arr IS VARRAY(1000) OF mytype;
>
> What i need to know is how to assign values to specific components of
> the object within the varray ?
>
> For example set the status component of the 5th varray element to
> 'hello'
>
> I have tried the following
>
> mytype_Arr(i).status := 'hello';

I don't quite understand but it looks that you don't have a variable instance of your type array 'mytype_Arr'. Try the following:

,----

| declare
|   abc mytype_Arr;
| begin
|   ... -- fill here the array
|   abc(i).status := 'hello';
| end;
| /

Harald Received on Wed Sep 03 2003 - 10:21:08 CDT