SQL Extractvalue Xpath Expression find first occurence

Question

I'm trying to extract the first occurrence in an xml message like this;

NVL(EXTRACTVALUE(message,'//ElementValue[1]'),NULL) as ElementValue

I get error:

XML - ORA-19025: EXTRACTVALUE returns value of only one node.

Any suggestions?

Community · Accepted Answer · 2017-05-23 10:33:52Z

Currently, the XPath would return every first ElementValue in a parent element. To actually return only the first occurrence of ElementValue in the entire document, you need to use parentheses before position index :

(//ElementValue)[1]

Also read @Dimitre Novatchev's answer here

Collectives™ on Stack Overflow

SQL Extractvalue Xpath Expression find first occurence

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related