Oracle Error ORA-19225: XPST0005 – XQuery static type error: expected non empty type got empty sequence

Oracle Error Message

ORA-19225: XPST0005 – XQuery static type error: expected non empty type got empty sequence

Reason for the Error

The static type assigned to an expression other than the () expression must not be the empty type.

Solution

Fix the expression so it does not return empty sequences.