Re: Question about XML and Oracle.

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 19 Nov 2010 18:30:07 +0100
Message-ID: <4ce6b41f$0$14255$ba620e4c_at_news.skynet.be>

John Peterson wrote:
> I'm not sure if this is the correct forum, but I'll give it a shot.
>
> I'm using the Oracle built-in XML functions to format a result set into
> an XML representation.
>
> However, I can't quite figure out how to "wrap" my results with a
> header/footer.
>
> For example, I want my output to be:
>
> <?xml version="1.0" encoding="UTF-8" ?>
> <OuterElement>
> <AllMyQueryResultsXML/>
> </OuterElement>
>
> I've successfully created a multi-row query that generates the
> <AllMyQueryResultsXML>. But, I can't figure out how to get the final
> step of wrapping those results in the version and <OuterElement> aspects.
>
> I know I can use XMLRoot for the version aspect. But the <OuterElement>
> eludes me. I've tried doing stuff like:
>
> select xmltype("<OuterElement>") from dual
> union all
> ...MyMultiRowQueryThatReturnsXMLTYPE...
> union all
> select xmltype("</OuterElement>") from dual
>
> But that doesn't work, because XMLTYPE expects well-formed XML. I've
> tried variations on the theme with XMLSERIALIZE and XMLCONCAT, but I
> can't seem to get it to work.
>
> Any help that anyone can provide would be *much* appreciated.
>
> Thanks!
>
>

SELECT XMLROOT ( XMLElement("OuterElement",

   "<AllMyQueryResultsXML/>"
), VERSION '1.0', STANDALONE YES)
    AS "XMLROOT" FROM DUAL; Received on Fri Nov 19 2010 - 11:30:07 CST