Oracle Error ORA-19025: EXTRACTVALUE returns value of only one node

Oracle Error Message

ORA-19025: EXTRACTVALUE returns value of only one node

Reason for the Error

Given XPath points to more than one node.

Solution

Rewrite the query so that exactly one node is returned.