special character in xml extract
485366Jan 24 2006 — edited Apr 16 2007Hi,
I got an xml like this
<?xml version="1.0" encoding="UTF-8"?>
<s:Message xmlns:s="http://ser.com/serve">
<s:Header>
<s:Context>
<s:Name>Contract</s:Name>
<s:Type>REPLY</s:Type>
</s:Context>
</s:Header>
</s:Message>
When I give
xml.extract('//s:Message/s:Header/s:Context/s:Type/text()').getStringVal();
it says
ORA-31013: Invalid XPATH expression
ORA-06512: at "SYS.XMLTYPE", line 0
How to resolve this??