FreeLists / oracle-l / Re: returning a query as a pipeline function

[William Robertson <william@xxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxx 
> <mailto:ryan_gaffuri@xxxxxxxxxxx>> 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