Re: SRF rescan testing

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