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

Home -> Community -> Usenet -> c.d.o.tools -> Oracle Nested Object question (varray)

Oracle Nested Object question (varray)

From: John Wright <gtaurine_at_hotmail.com>
Date: 2000/06/30
Message-ID: <395CC1B2.480F291D@hotmail.com>#1/1

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

Original text of this message

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