Hi lnd,
there is no other alternate to insert multiple rows into a nested table with a single statement ? if no it reduces my application performance dramatically.

think that i have to insert 10 rows into the nested table , it has to hit the database(server side) 10 times.this will reduces the performance .

I know that we can insert multiple rows into the nested tables based on select queries using 'cast' and 'multiset'. but my case is different the rows which i want to insert are not retrieved from the table.

i tried with cast and multiset also ,but it didn't work.

SQL> insert into table(select performance from member_info where name='guenther')
2 values(
3 cast(
4 multiset(
5 performance_ty('lo7','lo7',78),
6 performance_ty('lo8','lo8',89)
7 ) as perfromance_nt
8 )
9 );
multiset(
*
ERROR at line 4:
ORA-00904: invalid column name


thanks for any help

SrinivasM