Oracle Error ORA-19147: XQST0089: It is a static error if a variable bound in a for clause of a FLWOR expression, and its associated positional variable, do not have distinct names (expanded QNames)

Oracle Error Message

ORA-19147: XQST0089: It is a static error if a variable bound in a for clause of a FLWOR expression, and its associated positional variable, do not have distinct names (expanded QNames)

Reason for the Error

An error occurred during the processing of the XQuery expression.

Solution

Check the detailed error message for the possible causes.