Re: returning a query as a pipeline function

If you want to see an end-to-end example from an external table out through the pipeline function, do a little more reading on asktom.

here is the full example, where he fetches row by row.. explicit fetches though. nothing wrong with the implicit cursor for loop as William suggested also.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143

William Robertson <william_at_williamrobertson.net> wrote: In 10g you might as well get the rows via a Cursor FOR loop so it's an implicit bulk collect.
http://forums.oracle.com/forums/thread.jspa?threadID=592578

-----Original message-----
From: rjamya
Date: 4/12/07 02:53
> The whole concept of pipelined function is to pipe the row as soon as
> it is available ... so if you want, you can bulk collect it, but i'd
> rather pipe it as soon as it is fetched inside your function.
>
> developers using toad in production ... excellent. just remember ot
> ensure cs=exact in 9i ... else it might error out.
>
> Raj
> On Dec 3, 2007 12:17 PM,
> > wrote:
>
> do I need to
>
> select bulk collect into the object
>
> loop through the object and pipe it back row by row? Is there a
> better way?
>

--
http://www.freelists.org/webpage/oracle-l




       
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
--
http://www.freelists.org/webpage/oracle-l