How to fix the Oracle error LSX-00166: both content types must be mixed or both must be element-only?

In this post, you’ll learn more about the Oracle ErrorLSX-00166: both content types must be mixed or both must be element-only with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LSX-00166: both content types must be mixed or both must be element-only

Reason for the Error LSX-00166: both content types must be mixed or both must be element-only

Cause: If the content types of the derived type and base type are not the same simple type definition and the content type of the base type is not empty, then both content types must be mixed or both must be element-only. This was not the case, resulting in this error.

How to fix the Error LSX-00166: both content types must be mixed or both must be element-only ?

You can fix this error in Oracle by following the below steps

Action: Add attribute mixed=”true” or remove it.