Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

namespace qualifier and oracle xpath

170068Mar 15 2004 — edited Nov 27 2007
My element looks like <ns2:elem3>. XPATH //ns2:elem3 is valid in XMLSpy but invalid in Oracle.
I also tried extract(myxmltype,'//elem3','ns2'). I got ORA-31013: Invalid XPATH expression.
I can't find any example in Oracle document.
Has anyone tried successfully in specifying the namespace in extract() or extractValue() function?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 25 2007
Added on Mar 15 2004
#performance-availability, #xml-db
13 comments
37,196 views