September 29th, 2003, 06:13 PM
Join Date: Sep 2003
Time spent in forums: < 1 sec
Reputation Power: 0
more than 1 nested table
I am facing a problem with nested tables.I am trying to create a table with two nested tables in it.
create type book_type as object(bookname varchar2(20), bookid varcar2(20));/
create type book_type_tab as table of book_type;/
create type pen_type as object(pen_name varchar2(22), pen_color varchar2(20));/
create type pen_type_tab as table of pen_type;/
Then i craete a table with these two types as columns.
create table college(ssnid number, books book_type_tab, pens pen_type_tab)
nested table books store as books_nt, nested table pens store as pens_nt
((primary key(bookid, nested_table_id));
When i do this it gives me a error saying that it is not able to create the storage table for pens.
Is it not allowed to use two nested tables in a table.Plaese let me know if there is any problem with my creation of tables.
Thanks for any help.