title: XML file with CDATA values that contain multiple columns and records
body: <p>I'm having difficulty reading an XML file with CDATA values that contain multiple columns and records instead of usual markup entries as seen below:</p>
  
  <pre><code>    &lt;?xml version="1.0" encoding="UT32"?&gt;
        &lt;S:Env xmlns:S="http://soap.org/"&gt;
          &lt;S:Body&gt;
            &lt;ns2:request xmlns:ns2="http://ris.com/"&gt;
              &lt;arg0&gt;
                &lt;item&gt;
                  &lt;name&gt;IDVAR_SMLORT&lt;/name&gt;
                  &lt;value&gt; Beckumerstr./Beckenfarderweg ,  59302  Oelde&lt;/value&gt;
                &lt;/item&gt;
                &lt;item&gt;
                  &lt;name&gt;IDVAR_SMLJAHR&lt;/name&gt;
                  &lt;value&gt;16&lt;/value&gt;
                &lt;/item&gt;
                &lt;item&gt;
                  &lt;name&gt;IDVAR_MATRIX&lt;/name&gt;
                  &lt;value&gt;&lt;![CDATA[&lt;Matrix version="1"&gt;
                    &lt;Items&gt;
                      &lt;item id="i1" name="Code"/&gt;
                      &lt;item id="i2" name="Date"/&gt;
                    &lt;/Items&gt;
                    &lt;Infos&gt;
                      &lt;Info no="1"&gt;
                        &lt;Value itemId="i1"&gt;ZW&lt;/Value&gt;
                        &lt;Value itemId="i2"&gt;2016-03-22&lt;/Value&gt;
                      &lt;/Info&gt;
                      &lt;Info no="2"&gt;
                        &lt;Value itemId="i1"&gt;8502647794&lt;/Value&gt;
                        &lt;Value itemId="i2"&gt;EMAILG&lt;/Value&gt;
                      &lt;/Info&gt;
                      &lt;Info no="3"&gt;
                        &lt;Value itemId="i1"&gt;8502647794&lt;/Value&gt;
                        &lt;Value itemId="i2"&gt;TELP&lt;/Value&gt;
                      &lt;/Info&gt;
                    &lt;Infos&gt;
                  &lt;/Matrix&gt;
                  ]]&gt;&lt;/value&gt;
                &lt;/item&gt;
              &lt;/arg0&gt;
            &lt;/ns2:request&gt;
          &lt;/S:Body&gt;
        &lt;/S:Env&gt;
  </code></pre>
  
  <p>And this is the SQL statement I use to read the xmlfile above:</p>
  
  <pre><code>    SELECT ExtractValue( Value(p), '/item/name/text()')  as IdvarName,
             ExtractValue( Value(p), '/item/value/text()') as IdvarValue
      FROM   Table( XMLSequence (Extract( xmlFile, '/arg0/item' ))) p )
  </code></pre>
  
  <p>The XML file above has atleast 3 records. The first two are straight forward data but the last one is complex. It first defines the columns/fieldnames. Afterwards it takes multiples records. I'm able to read the first two but not the third one. Also, I notice that if I keep the URL address in the XML file, I can't read file and would result either runtime time error or no data found. But if I remove it, the SQL statement works alright.</p>
  
  <p>I'm already out of deep here. What should I change in my SQL statement to generate the result I needed? Can please someone help me? Thanks</p>