REF's and Varrays..help!

From: <saks1000_at_my-deja.com>
Date: Sun, 27 Jun 1999 02:24:04 GMT
Message-ID: <7l41vu$ci2$1@nnrp1.deja.com>

Does anybody know how to take the OIDs of an object table and put it into a varray? This is the setup:

declare

        person_clubs array_type;
begin

	SELECT ______ INTO person_clubs FROM
             clubs c WHERE c.Name = 'some_name';

end;

"array_type" is a varray of refs. The refs are associated to the same type of objects in the object tabble "clubs". Any ideas would be great! Thanks,

Pablo

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 26 1999 - 21:24:04 CDT