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@gmv.es>

Hi all,

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 - 10:25:01 CST