Oracle Error Message
ORA-19249: XQDY0029 – value does not match facet of the target type
Reason for the Error
The input value to a cast expression did not satisfy the facets of the target type.
Solution
Fix the value to conform to the facets of the target type.