Re: Oracle 8i Store proc return XML string

In article <GIyFF2.M43_at_news.boeing.com>, "Muon says...
>
>Hi all,
>
>I'd like to have a resultset back from stored proc. I know that we can
>concatenate fields and rows together into a long string and return it or
>using package to get the resultset(Microsoft Support Artical).
>
>I wonder if Oracle has something like 'FOR XML AUTO' like in SQL Server
>Stored Procedure or something else of that easy.
>
>Thanks,
>Muon
>
>

see
http://otn.oracle.com/tech/content.html

get the xml developers kit.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp