xml & oracle sp

From: Sander <x_at_x.nl>
Date: Thu, 18 Dec 2003 21:06:58 GMT
Message-ID: <SFoEb.206340$G77.96877@amsnews02.chello.com>

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 Received on Thu Dec 18 2003 - 15:06:58 CST