Oracle Error ORA-19249: XQDY0029 – value does not match facet of the target type

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.