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

Oracle Error Message

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

Reason for the Error

Given XPath does not point to a leaf node.

Solution

Rewrite the query so that a leaf node is returned.