Oracle Error ORA-19196: XMLType table or view is not allowed with this form of fn:collection

Oracle Error Message

ORA-19196: XMLType table or view is not allowed with this form of fn:collection

Reason for the Error

The table or view specified in fn:collection was of XMLType.

Solution

XMLType table or view is not allowed in the form of fn:collection(‘oradb:/schema/table/ROW/column’). It has to be a relational table or view.