how to fetch into varray

Hello,

I'm new to 8i NT and I am playing around with the new VARRAY and Object types. Chapter 4 of PL/SQL Users Guide and Reference talks about declaring a VARRAY type of a cursor rowtype. I am wondering how to fetch into that bad boy.

DECLARE
    CURSOR c1 IS SELECT * FROM user_tables;     TYPE user_type IS VARRAY(100) OF c1%ROWTYPE;     my_tables user_type := user_type(); BEGIN
    OPEN c1;
    FETCH c1 INTO my_tables;
    CLOSE c1;
END; Thanks,

Donnie Armstrong
darmstro_at_isd.net Received on Wed May 12 1999 - 21:11:55 CDT