My Oracle Support Banner

XML SchemaValidate Fails with LSX-00290: Invalid Enumeration Choice "grün" (Doc ID 1930727.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


The database has a non utf8 character set such as WE8MSWIN1252.
Following XML schema

<xs:schema xmlns:xs="" elementFormDefault="qualified" attributeFormDefault="unqualified">
    <xs:element name="person">
            <xs:documentation>Comment describing your root element</xs:documentation>
                <xs:element name="name">
                        <xs:restriction base="xs:string">
                            <xs:maxLength value="10"/>
                <xs:element name="lieblingsfarbe">
                        <xs:restriction base="xs:string">
                            <xs:maxLength value="4"/>
                            <xs:enumeration value="rot"/>
                            <xs:enumeration value="grün"/>
                            <xs:enumeration value="gelb"/>
                            <xs:enumeration value="blau"/>

is registered with
dbms_xmlschema.registerschema(schemaurl => vschema,
                                 schemadoc => bfilename(vpath, vschema),
                                 local => true,
                                 gentypes => false,
                                 genbean  => false,
                                 gentables     => TRUE,
                                 force         => TRUE,
                                 csid          => nls_charset_id('AL32UTF8'),
                                 enablehierarchy  => DBMS_XMLSCHEMA.ENABLE_HIERARCHY_CONTENTS,
                                 options => dbms_xmlschema.register_binaryxml);

When validating  a document containing diacritics,  e.g.

with vxml.createSchemaBasedXML, it raises:

ORA-31038: Invalid enumeration value: "grün"
in and, while the error is
LSX-00290: invalid enumeration choice "grün"
in + PSU


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.