Re: Is it possible this nested table?

A copy of this was sent to Adolfo Sánchez <adfsanchez_at_gmv.es> (if that email address didn't require changing) On Mon, 20 Dec 1999 17:25:01 +0100, you wrote:

>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;

because VALUES is a reserved word -- change the name of the column to something else other the VALUES (thats used in the INSERT statement)

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Dec 20 1999 - 11:29:39 CST