PL/SQL Help

How do I insert the values returned by a select into a varray.

So, I have a table, TABLE and I want to select COL_A and insert into the varray:

cursor c1 is select * from TABLE
type myarray is varray(100) of TABLE.COL_A%TYPE;

thearray myarray;
 i int := 1;

begin

    for c1_rec in c1 loop

        thearray(i) = c1_rec.COL_A /*this is what I want to do, but it does not compile*/

        i := i + 1;
    end loop;
end; Received on Tue Jun 08 1999 - 05:06:23 CDT