title: Get XMLElement from Oracle XMLTABLE with namespaces
body: <p>My first question, please forgive errors ....</p>
  
  <p>I have this XML, from the Bank Of Canada, Average Daily Exchange Rate</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;rdf:RDF    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
              xmlns="http://purl.org/rss/1.0/"
              xmlns:cb="http://www.cbwiki.net/wiki/index.php/Specification_1.1"
              xmlns:dc="http://purl.org/dc/elements/1.1/"&gt;
    &lt;channel rdf:about="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD"&gt;
      &lt;title&gt;Daily exchange rates&lt;/title&gt;
      &lt;link&gt;http://www.bankofcanada.ca/?p=39898&lt;/link&gt;
      &lt;description&gt;Daily average exchange rates - published once each business day by 16:30 ET. All Bank of Canada exchange rates are indicative rates only.&lt;/description&gt;
      &lt;items&gt;
        &lt;rdf:Seq&gt;
          &lt;rdf:li rdf:resource="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD" /&gt;
        &lt;/rdf:Seq&gt;
      &lt;/items&gt;
      &lt;dc:language&gt;en&lt;/dc:language&gt;
    &lt;/channel&gt;
    &lt;item rdf:about="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD"&gt;
      &lt;title&gt;CA: 1.3475 CAD = 1 USD 2017-03-08&lt;/title&gt;
      &lt;link&gt;http://www.bankofcanada.ca/?p=39898&lt;/link&gt;
      &lt;description&gt;1 USD = 1.3475 CAD (US dollar to Canadian dollar daily exchange rate)&lt;/description&gt;
      &lt;dc:date&gt;2017-03-08T21:30:00Z&lt;/dc:date&gt;
      &lt;dc:language&gt;en&lt;/dc:language&gt;
      &lt;cb:statistics&gt;
        &lt;cb:country&gt;CA&lt;/cb:country&gt;
        &lt;cb:exchangeRate&gt;
          &lt;cb:value decimals="4"&gt;1.3475&lt;/cb:value&gt;
          &lt;cb:baseCurrency&gt;CAD&lt;/cb:baseCurrency&gt;
          &lt;cb:targetCurrency&gt;USD&lt;/cb:targetCurrency&gt;
          &lt;cb:rateType&gt;Bank of Canada exchange rate&lt;/cb:rateType&gt;
          &lt;cb:observationPeriod frequency="daily"&gt;2017-03-08T21:30:00Z&lt;/cb:observationPeriod&gt;
        &lt;/cb:exchangeRate&gt;
      &lt;/cb:statistics&gt;
    &lt;/item&gt;
  &lt;/rdf:RDF&gt;
  </code></pre>
  
  <p>And I have this Oracle PL/Sql to get some of the values, it returns a single row but it is not returning any data. All columns are blank or null, I am missing something but I'm not sure what? I an running this in an Oracle 11g database.</p>
  
  <pre><code>with xml_data AS
  (select xmltype(
  '&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;rdf:RDF    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
              xmlns="http://purl.org/rss/1.0/"
              xmlns:cb="http://www.cbwiki.net/wiki/index.php/Specification_1.1"
              xmlns:dc="http://purl.org/dc/elements/1.1/"&gt;
    &lt;channel rdf:about="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD"&gt;
      &lt;title&gt;Daily exchange rates&lt;/title&gt;
      &lt;link&gt;http://www.bankofcanada.ca/?p=39898&lt;/link&gt;
      &lt;description&gt;Daily average exchange rates - published once each business day by 16:30 ET. All Bank of Canada exchange rates are indicative rates only.&lt;/description&gt;
      &lt;items&gt;
        &lt;rdf:Seq&gt;
          &lt;rdf:li rdf:resource="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD" /&gt;
        &lt;/rdf:Seq&gt;
      &lt;/items&gt;
      &lt;dc:language&gt;en&lt;/dc:language&gt;
    &lt;/channel&gt;
    &lt;item rdf:about="http://www.bankofcanada.ca/valet/fx_rss/FXUSDCAD"&gt;
      &lt;title&gt;CA: 1.3475 CAD = 1 USD 2017-03-08&lt;/title&gt;
      &lt;link&gt;http://www.bankofcanada.ca/?p=39898&lt;/link&gt;
      &lt;description&gt;1 USD = 1.3475 CAD (US dollar to Canadian dollar daily exchange rate)&lt;/description&gt;
      &lt;dc:date&gt;2017-03-08T21:30:00Z&lt;/dc:date&gt;
      &lt;dc:language&gt;en&lt;/dc:language&gt;
      &lt;cb:statistics&gt;
        &lt;cb:country&gt;CA&lt;/cb:country&gt;
        &lt;cb:exchangeRate&gt;
          &lt;cb:value decimals="4"&gt;1.3475&lt;/cb:value&gt;
          &lt;cb:baseCurrency&gt;CAD&lt;/cb:baseCurrency&gt;
          &lt;cb:targetCurrency&gt;USD&lt;/cb:targetCurrency&gt;
          &lt;cb:rateType&gt;Bank of Canada exchange rate&lt;/cb:rateType&gt;
          &lt;cb:observationPeriod frequency="daily"&gt;2017-03-08T21:30:00Z&lt;/cb:observationPeriod&gt;
        &lt;/cb:exchangeRate&gt;
      &lt;/cb:statistics&gt;
    &lt;/item&gt;
  &lt;/rdf:RDF&gt;'
  ) xmlcol from dual
  )
  SELECT length(x1.xmlcol) as x_len, x2.title
  from   xml_data  x1,
         XMLTABLE (
           XMLNAMESPACES (
             'http://www.w3.org/1999/02/22-rdf-syntax-ns#'            AS "rdf",
             'http://www.cbwiki.net/wiki/index.php/Specification_1.1' AS "cb",
             'http://purl.org/dc/elements/1.1/'                       AS "dc"),
           '/rdf:RDF'
           PASSING x1.XMLCOL
           COLUMNS 
               title  VARCHAR2 (1024) PATH '/channel/title'
           ) x2
  </code></pre>