Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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"Received on Thu Dec 18 2003 - 15:14:13 CST