Re: Coding question - piping rows from a function

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