Re: Returning multiple columns from Stored Procedure for use in a View.

john.roberts.2004_at_gmail.com wrote:
> Hello,
>
> I am using an oracle view to retreive data from many tables.
> My view calls a function to perform some complex calculations.
>
> I would like to be able to call the function (or stored procedure) once
> in my view,
> and have it return multiple columns of data for my view.
>
> I am sure this is possible, but I am not sure how to do it.
>
> Any direction would be great.
> Thanks for your help,

Sybrand's rant is on target ... version matters. If you want to see demos of pipelined table functions they can be found in Morgan's Library at www.psoug.org. In the future post version and edition.

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