Re: xml & oracle sp

Sander wrote:

> Hi,
>
> Hope any one can give me some direction on the following.
>
> I am fairly new to oracle, but know some about SQl server. I am looking for
> an ' easy' way to write a SP which outputs an simpel XML string based on
> the results of a query (like FOR XML AUTO in SS). I am using 9i standard 1
> release, so as I understand, no nifty XMLElement functions. The best,
> simpelst way would be to use a cursor, loop it and just write the xml tags
> and values my self. Is this the best solution and if so, how does this go in
> a Oracle SP.
> I understand it is possible to use the DOM in pl/sql. Can someone tell me
> how I go about that (from scratch)?? Any help much appreciated!
>
> Sander
> tillebuorren_at_zonnet.nl

Everything you need is already in the RDBMS. Go to http://otn.oracle.com and look up XML.

Also go to http://oramag.oracle.com. There were a number of good articles this year with demos and code samples.

-- 
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)