Hi
Is it possible to read a CDATA section from an xml file and load just a CDATA section into a dataset.
Example of XML file

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header>
        <msgName>schema</msgName>
    </soapenv:Header>
    <soapenv:Body>
        <msgResponse>
         <origMsgName> getSchema </origMsgName>
        <msgStatus> PASS </msgStatus>
        <response>
        <msgText>
        <Script>
            <![CDATA[
            <?xml version="1.0" standalone="yes"?>
            <xs:schema id="NewDataSet" xmlns=""xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
            <xs:element name="NewDataSet" msdata:IsDataSet="true">
                <xs:complexType>
                  <xs:choice maxOccurs="unbounded">
                    <xs:element name="FORECAST_TYPE" msprop:BaseTable.0="FORECAST_TYPE">
                <xs:complexType>
                    <xs:sequence>
                    <xs:element name="FORECAST_TYPE_CODE" msprop:OraDbType="126" msprop:BaseColumn="FORECAST_TYPE_CODE" type="xs:string" minOccurs="0" />
                    <xs:element name="CODE_DESC" msprop:OraDbType="126" msprop:BaseColumn="CODE_DESC" type="xs:string" minOccurs="0" />
                      <xs:element name="ASSIGNMENT_ID" msprop:OraDbType="107" msprop:BaseColumn="ASSIGNMENT_ID" type="xs:decimal" minOccurs="0" />
                    </xs:sequence>
                  </xs:complexType>
                </xs:element>
              </xs:choice>
            </xs:complexType>
          </xs:element>
        </xs:schema>
        ]]>
        </Script>
</msgText>
    <warnings>Warnings Text</warnings>
    </response>
        </msgResponse>
    </soapenv:Body>
</soapenv:Envelope>

i just want to load this CDATA section form this XML file into a datset.

Regards



Mahesh

__________________
Mahesh

If you're using XSLT, the fact that it's a CDATA section is irrelevant: CDATA is just an alternative way of escaping special characters. So

<a><![CDATA[<<<]]></a>

is just another way of writing

<a>&lt;&lt;&lt;</a>

But you can output the content of the <Script> element to a file using:

<xsl:stylesheet ...

<xsl:output method="text"/>
<xsl:template match="/">
  <xsl:value-of select="//Script"/>
</xsl:template>

</xsl:stylesheet>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference