Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REF CURSOR returning a PL/SQL Table.
On 5 Feb 2002, galenboyer_at_hotpop.com wrote:
> query := 'select * from TABLE ( cast (l_data as
> groupSize3Array ))';
>
> OPEN cvar FOR query;
It seems that changing the OPEN call to
OPEN cvar FOR
select * from TABLE ( cast (l_data as groupSize3Array ))
Did the trick.
Still don't really understand why.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Thu Feb 07 2002 - 20:47:09 CST