XML Database (MOSC)

MOSC Banner

XMLTable problems showing XML

edited May 13, 2013 11:56AM in XML Database (MOSC) 2 commentsAnswered ✓
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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center