Hi,

What is wrong with the following code ?

TIA
Rd


declare
type r1 is record (c1 varchar2(1), c2 number );

type t1 is table of r1 index by binary_integer;

tab1 t1 ;
begin
select c1,c2
bulk collect into tab1
from table1;
....
....
end;

Oracle LazyDBA home page