-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|