I have a problem with VARRAYS / OBJECT TYPES

From: Matthias Conrad <mconrad_at_imn.htwk-leipzig.de>
Date: Sat, 21 Jul 2001 21:51:40 GMT
Message-ID: <9g7rqd$2cd$1_at_news.uni-leipzig.de>


I have a problem with VARRAYS.
With the following script there is an error when creating the VArray -> TypVa_STUDENT .
"Type created with compilation errors" (Oracle SQLPlus)

I can't explain why.
Could it be that with the Type Typ_STUDENT the attribute COURSE already is a type
which doesn't allow the VArray TypVa_STUDENT to be created

B.B.
Matthias

create type Typ_COURSE as object
 (

     MARK  varchar2(200) ,
     SECTION  varchar2(200) ,
     COURSENAME varchar2(200)

 );
/

create type TypVa_COURSE as
 varray(10) of Typ_COURSE ;
/

create type Typ_STUDENT as object
 (
     FNAME  varchar2(200) ,
     LNAME  varchar2(200) ,
     COURSE  TypVa_COURSE

 );
/

create type TypVa_STUDENT as
 varray(10) of Typ_STUDENT );
/

create table tblREPORTCARD
 (

     STUDENT TypVa_STUDENT
 );
/
Received on Sat Jul 21 2001 - 23:51:40 CEST

Original text of this message