Re: returning a query as a pipeline function
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: william@xxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 4 Dec 2007 11:52:38 -0800 (PST)
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@xxxxxxxxxxxxxxxxxxxx> 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?
>
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
Other related posts:
