Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Oracle Nested Object question (varray)
I have to create some objects in oracle 8i I am wondering if REF can be used with VARRAY
suppose I have:
create type ALIAS_VA as varray(10) of VARCHAR2(20);
create type ADDRESS_TY as object
( Street VARCHAR2(20),
City VARCHAR2(20));
create type PERSON as object
( Name VARCHAR2(20),
Alias ALIAS_VA, Address ADDRESS_TY));
SQL*PLUS told me "Type created with compilation errors"
I put REF before ALIAS_VA, it didn't help neither.
Is there anything else I can do?
Thanks a lot!
John Received on Fri Jun 30 2000 - 00:00:00 CDT
![]() |
![]() |