On Mar 20, 12:21 am, "Dereck L. Dietz" <diet..._at_ameritech.net> 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.
No, unfortunately you can't. It would rather defeat the piping
behaviour anyway if you could.
Received on Tue Mar 20 2007 - 05:45:38 CDT
