i want to insert a second value in a nested table i have write this in developer6i but it won't work(it works under sqlplus)
**insert into resultat values(1.2,ens_ter_doc(ter_doc(15,16)));
(this line works in both dev6i and sqlplus)
but here is the probleme:
**insert into table(@select TD
from resultat
where coef=1.2)
the compiler stops at @
what can i do?
this is how i have created my table and types
create type ter_doc as object(ter number,doc number)/
create type ens_ter_doc as table od ter_doc/
create table resultat(
coef float,
TD ens_ter_doc)
nested table TD store as TDS;