Oracle Database 12c New Features

ORA-19226: XPTY0006 - XQuery dynamic type mismatch: expected string got string

ORA-19226: XPTY0006 - XQuery dynamic type mismatch: expected string got string

Cause:

The expression could not be used because it's dynamic type did not match the required type as specified by XQuery sequencetype matching rules.


Action:

Fix the expression to return the expected type or use appropriate cast functions.