xmltype extractValue with namespace raise exception "invalid token"
916932Apr 5 2012 — edited Apr 5 2012Hello. I have XML which stored as XMLTYPE and with content such as:
+<notificationEF>+
+<oos:id>2812301</oos:id>+
When I trying to execute
extractValue(XML_CLOB, 'notificationEF/oos:id')
I catch exception "LPX-00601: Invalid token in: 'notificationEF/oos:id'"
What's wrong? And how can i fix this?
Thank you.