Including CLOB data in an XML document

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 21 Jul 2005 05:44:47 -0700
Message-ID: <1121949887.198427.315980@g43g2000cwa.googlegroups.com>

I know how to store a XML document as a CLOB and object relationally.

I know how to generate an XML document from a query.

What I want to know is when I generate a document from a query, and the table I
queried has a clob column how can I get that column to be represented with the
actual data inside the xml document instead of a tag that just says <column>(CLOB)</column>

Do I have to make it a CDATA section? Can I do that with dbms_xmlquery.getXML? Received on Thu Jul 21 2005 - 07:44:47 CDT