
Untitled
By: a guest on
May 27th, 2012 | syntax:
None | size: 0.52 KB | hits: 14 | expires: Never
Why bulk collect into clause is limiting the size of nested table in pl/sql
declare
type yy is table of t12.name%type;
y yy:=yy();
n number:=1;
begin
y.extend(10);
select name bulk collect into y from t12;
--select name into y(5) from t12 where id=1; If i uncomment this line it gives error
for i in (select name from t12)
loop
dbms_output.put_line(y(n));
n:=n+1;
end loop;
end;
declare
type yy is table of t12.name%type;
y yy;
begin
select name bulk collect into y from t12;
end;