Oracle Error ORA-19224: XPTY0004 – XQuery static type mismatch: expected – string got – string

Oracle Error Message

ORA-19224: XPTY0004 – XQuery static type mismatch: expected – string got – string

Reason for the Error

The expression could not be used because it’s static type is not appropriate for the context in which it was used.

Solution

Fix the expression to be of the required type or add appropriate cast functions around the expression.