How to fix the Oracle error LPX-01018: [XPTY0018] Path last step contains both nodes and atomic values?

In this post, you’ll learn more about the Oracle ErrorLPX-01018: [XPTY0018] Path last step contains both nodes and atomic values with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LPX-01018: [XPTY0018] Path last step contains both nodes and atomic values

Reason for the Error LPX-01018: [XPTY0018] Path last step contains both nodes and atomic values

Cause: It is a type error if the result of the last step in a path expression contains both nodes and atomic values.

How to fix the Error LPX-01018: [XPTY0018] Path last step contains both nodes and atomic values ?

You can fix this error in Oracle by following the below steps

Action: None