How to fix the Oracle error LSX-00162: string “~S” is an invalid default for the complex type?

In this post, you’ll learn more about the Oracle ErrorLSX-00162: string “~S” is an invalid default for the complex type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LSX-00162: string “~S” is an invalid default for the complex type

Reason for the Error LSX-00162: string “~S” is an invalid default for the complex type

Cause: If the {content type} is a simple type definition, then the string must be valid with regard to the simple type definition as defined by String Valid (3.14.4). If the {content type} is mixed, then the {content type}’s particle must be emptiable as defined by Particle Emptiable (3.9.6). However, one of these conditions was not met, resulting in this error.

How to fix the Error LSX-00162: string “~S” is an invalid default for the complex type ?

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

Action: Make the default string a valid default with regard to the complex type definition.