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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
