Oracle Solution for Error ora-19025

Solution for Oracle Error ORA-19025

ORA-19025: EXTRACTVALUE returns value of only one node

What triggered the Error:

Given XPath points to more than one node.

What should we do to fix it:

Rewrite the query so that exactly one node is returned.