Oracle Error ORA-19035: Invalid select item of the query in newContextFromHierarchy()

Oracle Error Message

ORA-19035: Invalid select item of the query in newContextFromHierarchy()

Reason for the Error

The query does not have a number select item followed by an XMLType select item only.

Solution

Make sure the result set of the query used in the newContextFromHierarchy() must have only two selected items: the first item must be number type and the second item must be XMLType.