Re: xml & oracle sp

Have a look at the XML tools on Technet (http://www.technet.com).

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"