XMLTable problems showing XML
Hello,I have an APEX application which shows XML information given by a Web Service.
But the query with XMLtable doesn't return data. I think that the problem is the "m:" in every tag.
Could you help me, please?
I paste the query with the problematic XML:
select xtab."veces"
, xtab."uniMdCobr"
, xtab."planta"
, xtab."nombre"
, xtab."mdCobro"
, xtab."impMdCobr"
, xtab."diferencia"
, xtab."decReco"
, xtab."decCta"
, xtab."cajera"
from (Select xmltype('
<m:consultaCuadreCajerasResponse xmlns:m="http://company.es/">
<return>
<m:results xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" soapenc:arrayType="m:CuadreCajera[2]">
<m:item>
<m:cajera>000001</m:cajera>
But the query with XMLtable doesn't return data. I think that the problem is the "m:" in every tag.
Could you help me, please?
I paste the query with the problematic XML:
select xtab."veces"
, xtab."uniMdCobr"
, xtab."planta"
, xtab."nombre"
, xtab."mdCobro"
, xtab."impMdCobr"
, xtab."diferencia"
, xtab."decReco"
, xtab."decCta"
, xtab."cajera"
from (Select xmltype('
<m:consultaCuadreCajerasResponse xmlns:m="http://company.es/">
<return>
<m:results xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" soapenc:arrayType="m:CuadreCajera[2]">
<m:item>
<m:cajera>000001</m:cajera>
0