Accessing components of an object within a varray...

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';

and have the following error..

PLS-00363: expression 'mytype_Arr.status' cannot be used as an assignment target

Any help ?

Will Received on Wed Sep 03 2003 - 09:12:39 CDT