This content has been marked as final. Show 2 replies
extractvalue(xmltype(DETAIL),'*/Header2/A1/name') d1You're trying to extract a child element of A1 whose name is "*name*".
Rhetorical question : is there such an element?
There's an attribute whose name is "*Name*" though. In the XPath language, attribute are accessed via the @ prefix or the attribute:: axis.
And depending on your unknown version, you may want to XMLTable() instead of extractValue().