Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multi level nested table

Status
Not open for further replies.

iuanee

Programmer
Jun 13, 2003
26
0
0
US
hi, i am trying to create a multi-level nested table with the following schema..

create type typeA(
...
...
)

create type typeA_ntabtyp as table of typeA;

create type typeB(
...
a typeA_ntabtyp;
)

create type typeB_ntabtyp as table of typeB;


create type typeC(
...
b typeB_ntabtyp;
)

all of the above works fine

but when i create a table of typeC, it gives me an error:

create table tableC of typeC
NESTED TABLE a STORE AS a_ntab(
NESTED TABLE b STORE AS b_ntab
);

ERROR at line 1:
ORA-22913: must specify table name for nested table column or attribute

i've already provided a, b and their table name as shown above....

anyone know the correct way of doing it??

thanks,

iuanee
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top