DEREF a collection of REF

From: jfj <ffm_at_hgh.com>
Date: Sat, 21 Dec 2002 16:25:59 +0100
Message-ID: <3e048843$0$22297$626a54ce_at_news.free.fr>

hi,
how can i dereference a collection of REF to an other table's objects. for example:

create type A as object(
name varchar2);

create type collection as table of REF A;

create type B as object (
name_of_team varchar2,
refrence_to_A collection);

select on nested table only gives for each row multiple reference to A, but not A itself even with DEREF operator. How can it be done ?? thank you! Received on Sat Dec 21 2002 - 16:25:59 CET