Oracle Solution for Error ora-19026

Solution for Oracle Error ORA-19026

ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

What triggered the Error:

Given XPath does not point to a leaf node.

What should we do to fix it:

Rewrite the query so that a leaf node is returned.