Is it possible this nested table?

From: Adolfo Sánchez <adfsanchez_at_gmv.es>
Date: Mon, 20 Dec 1999 17:25:01 +0100
Message-ID: <385E585C.337CF6ED_at_gmv.es>



[Quoted] Hi all,

[Quoted] Why there is an error in this sql file when I create the table parameter_values_table?

drop type parameter_type;
drop type value_table;
drop type value_type;
drop table opmode_table;
drop type opmode_type;

create type opmode_type as object(
 name varchar(10));
/

create table opmode_table of opmode_type;

create type value_type as object(
 value number,
 opmode ref opmode_type);
/

create type value_table as table of value_type;
/

create type parameter_type as object(
 name varchar(10));
/

create table parameter_values_table(
parameter parameter_type,
values value_table)
nested table values store as parameter_values;

--
____________________________________________________________________
Adolfo Sánchez Domínguez   GMV, S.A.  Grupo de Mecánica de Vuelo
mailto:adfsanchez_at_gmv.es   Sector Foresta,1.  TRES CANTOS
PHO: +34 91 806 4443       E-28760 MADRID (SPAIN)
FAX: +34 91 806 4641       http://www.gmv.es
Received on Mon Dec 20 1999 - 17:25:01 CET

Original text of this message