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>
);
/
create type TypVa_COURSE as
varray(10) of Typ_COURSE ;
/
create type Typ_STUDENT as object
(
);
/
create type TypVa_STUDENT as
varray(10) of Typ_STUDENT );
/
create table tblREPORTCARD
(
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