Oracle Error ORA-19279: XPTY0004 – XQuery dynamic type mismatch: expected singleton sequence – got multi-item sequence

Oracle Error Message

ORA-19279: XPTY0004 – XQuery dynamic type mismatch: expected singleton sequence – got multi-item sequence

Reason for the Error

The XQuery sequence passed in had more than one item.

Solution

Correct the XQuery expression to return a single item sequence.