XMLTYPE.ExtractValue and xmlns="" doesn't work
Hi,
DB 9.2.0.4
I have put a simple xml into xmltype column:
<?xml version = '1.0' encoding = 'UTF-8'?>
<b:yyy xmlns:b="qwert">
<xxx xmlns="">
aaaaaaaaaaaa
</xxx>
</b:yyy>
I can't get value of xxx element:
Following sql doesn't work:
select Extract(x.indata,'//xxx'),ExtractValue(x.indata,'//xxx')
from testtable x
the query returns null values
Could someone tell me what is going wrong ?
Thansk in advance !
Regards,
Cezary