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.