Re: returning a query as a pipeline function

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, <ryan_gaffuri_at_comcast.net
> <mailto:ryan_gaffuri_at_comcast.net>> 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