Re: returning a query as a pipeline function

  • From: William Robertson <william@xxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 04 Dec 2007 08:40:41 +0000

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?



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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2007