Re: xml & oracle sp

Sander wrote:

> Hi Daniel,
>
> thanx for your swift response. That would be a great thing if oracle
> supported thing I am looking for. Off course I checked the Oracle site but
> if you look for XML there, you get lost. Could you give some more details.
>
> In plain, i need a way to translate relational data to an XML string using a
> stored procedure. Nothing fancy. Is XMLDB the thing I am looking for? Seems
> to me this is much more then just an extension on RDBMS.
>
> Thanx.
>
> Sander

It is indeed far more. Try this:

Go to http://www.psoug.org and under "What's Hot" click on the first item ... July Meeting Presentation. Scroll down until you find "Creating XML From A Nested Table". Is that what you are looking for?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)