Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Coding question - piping rows from a function
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1174357173.893222_at_bubbleator.drizzle.com...
> Dereck L. Dietz wrote:
> > "DA Morgan" <damorgan_at_psoug.org> wrote in message
> > news:1174350872.555877_at_bubbleator.drizzle.com...
> >> Dereck L. Dietz wrote:
> >>> If I write a function which has a cursor in it, is it possible to pipe
> > the
> >>> returned rows
> >>> back to a procedure where the row information can be processed?
> >>>
> >>> Something like:
> >>>
> >>> LOOP
> >>>
> >>> data_row_object := piped_function();
> >>>
> >>> ... process data_row_object ...
> >>>
> >>> END LOOP;
> >>>
> >>> I know I can write table functions which return the piped rows
directly
> > into
> >>> a table to be
> >>> inserted but I don't necesarily want to do that in this case if I can
> > find a
> >>> way to do it.
> >> What you are looking for is a PIPELINED TABLE FUNCTION.
> >>
> >> www.psoug.org and click on Morgan's Library
> >> Scroll down and click on PIPELINED TABLE FUNCTIONS.
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damorgan_at_x.washington.edu
> >> (replace x with u to respond)
> >> Puget Sound Oracle Users Group
> >> www.psoug.org
> >
> > Yes I know but can I return the values into a procedure or just into a
table
> > itself? I've had to try to teach myself pipelined table functions and
all
> > I've been able to do has been the pipeline table function into a final
> > table.
>
Yes and I didn't see any examples of what I really want to do. Received on Mon Mar 19 2007 - 21:43:58 CDT