Hannu Krosing wrote:
> 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
>
After a quick look, this appears to be a very relevant document. Does
anyone know if this is new in 9i?
Joe