Re: Coding question - piping rows from a function

"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. Received on Mon Mar 19 2007 - 19:52:55 CDT