Re: xml & oracle sp

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
"Daniel Morgan" <damorgan_at_x.washington.edu> schreef in bericht news:1071791218.166476_at_yasure...
> 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)
>
Received on Fri Dec 19 2003 - 03:27:00 CST