Hi Everybody,.
Does Multilevel Collections and Bulk Sql is supported by 8.1.7...i know it is supported by 9i...if anybody have any idea pls give the suggestions.

for example i tried the follo......

SQL> create type t1 is varray(10) of integer;
2 /

Type created.

SQL> create table tab1(c1 t1);

Table created.

SQL> insert into tab1 values(t1(1234,1235,1236));

1 row created.

SQL> insert into tab1 values(t1(2,3,4));

1 row created.


SQL> declare
2 type t2 is table of t1;
3 v2 t2;
4 begin
5 select c1 bulk collect into v2 from tab1;
6 dbms_output.put_line(v2.count) ;
7 end;
8 /
type t2 is table of t1;
*
ERROR at line 2:
ORA-06550: line 2, column 12:
PLS-00534: A Table type may not contain a nested table type or VARRAY.
ORA-06550: line 2, column 1:
PL/SQL: Item ignored


thanks in advance
pras