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: refcursor for pipeline table function?

Re: refcursor for pipeline table function?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 10 Jun 2003 05:26:04 GMT
Message-ID: <MZdFa.70013$S9.1996242@twister.socal.rr.com>


Ganesh Raja wrote:
>
> See if this Helps....

<snip>
> cursor cur_dummy is
> select *
> from Table(Cast(ttab(NULL,NULL) as ttab));
> type trefcur is ref cursor return cur_dummy%rowtype;

Thanks! Based on your input I got it to work with this ...

cursor cur is select * from table(ttab()); type trefcur is ref cursor return cur%rowtype;

Thanks again,
Richard Received on Tue Jun 10 2003 - 00:26:04 CDT

Original text of this message

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