Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: refcursor for pipeline table function?
Jusung Yang wrote:
>
> Richard Kuhler <noone_at_nowhere.com> wrote in message news:<J9AFa.80395$x67.3672926_at_twister.socal.rr.com>...
>
> > The solution you showed has a major drawback in that
> > you've duplicated the entire declaration of your object to make your
> > record.
>
> Nah... If you take a closer look you would notice that they, the
> object type and the record type, have different structures. There are
> 3 distinct data structures in that little example: the table record,
> the record in the refcursor and the SQL object type you use to pipe
> row out of the pipelined function. All of them can be different.
<snip>
Oh, so your solution just isn't the answer to my question. What I was asking for is a reference cursor for the results coming back from the pipeline table function. You've defined a reference cursor for some completely different entity. The first poster pointed out how to accomplish what I actually needed.
Thanks anyways,
Richard
Received on Wed Jun 11 2003 - 14:11:59 CDT