Oracle Error ORA-19238: XPTY0018 – It is a type error if the result of the last step in a path expression contains both nodes and atomic values

Oracle Error Message

ORA-19238: XPTY0018 – It is a type error if the result of the last step in a path expression contains both nodes and atomic values

Reason for the Error

An error occurred during the processing of the XQuery expression.

Solution

Check the detailed error message for the possible causes.