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