Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: REF CURSOR returning a PL/SQL Table.

Re: REF CURSOR returning a PL/SQL Table.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 7 Feb 2002 20:47:09 -0600
Message-ID: <u4rkso749.fsf@rcn.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US