On Sun, 2002-05-26 at 21:55, Joe Conway wrote:
> Tom Lane wrote:
> >>3. PL/pgSQL support for returning sets -- this seems to me like an
> >>important item if SRFs are to be useful to the masses. Any pointers on
> >>how to approach this would be appreciated.
> >
> > Does Oracle's pl/sql support this? If so what does it look like?
>
> I *think* Oracle pl/sql can return (the equivilent of) setof composite
> using a special Oracle package (DBMS_OUTPUT, see:
> http://www.ora.com/catalog/oraclebip/chapter/ch06.html), but it cannot
> be used as a row source in a FROM clause. Hopefully an Oracle guru will
> correct or add to this.
I'm no Oracle guru, but this is what a quick Google search found me:
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89856/08_subs.htm#19677
-------------
Hannu