Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Coding question - piping rows from a function

Re: Coding question - piping rows from a function

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 20 Mar 2007 02:43:58 GMT
Message-ID: <OTHLh.10151$M65.9778@newssvr21.news.prodigy.net>

"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.

>

> 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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US