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.
Did you look at the examples in the provided link?
--
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
Received on Mon Mar 19 2007 - 21:19:34 CDT
