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

ERRORXPTY0004 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
CAUSEThe XQuery sequence passed in had more than one item.
ACTIONCorrect the XQuery expression to return a single item sequence.