XML Database (MOSC)

MOSC Banner

ORA-31038: Invalid enumeration value: " "

edited June 2012 in XML Database (MOSC) 5 commentsAnswered
Oracle problem to validate xml with white space?

I have one attribute named tipoOperacion, which is a enumeration type with two values:

<xs:enumeration value=" " />

<xs:enumeration value="S" />

I get error oracle (ORA-31038: Invalid enumeration value: "") because white space in enumeration is not valid.

because it is not valid the space to validate the schema?

DECLARE

schemaURL VARCHAR2(256) := 'XSDModeloF.xsd';XSDModeloF CONSTANT CLOB :='<?xml version="1.0" encoding="utf-8"?><xs:schema id="XSDModeloF" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="unqualified"><xs:element name="Solicitud_Registro_Entrada"><xs:complexType><xs:sequence><xs:element ref="Datos_Firmados" /></xs:sequence><xs:attribute name="version" type="xs:decimal" use="required" /></xs:complexType></xs:element><xs:element name="Datos_Firmados"><xs:complexType><xs:sequence><xs:element ref="Datos_Genericos" /><xs:element ref="Datos_Especificos" /><xs:element ref="Documentos" /></xs:sequence></xs:complexType></xs:element><xs:element name="Documentos"><xs:complexType/></xs:element><xs:element name="Datos_Genericos"><xs:complexType><xs:sequence><xs:element ref="Destino" /></xs:sequence></xs:complexType></xs:element><xs:element name="Descripcion" type="xs:string"/><xs:element name="Codigo" type="xs:string"/><xs:element name="Destino"><xs:complexType><xs:sequence><xs:element ref="Codigo"/><xs:element ref="Descripcion"/></xs:sequence></xs:complexType></xs:element><xs:element name="Nombre" type="xs:string" /><xs:element name="Apellidos"><xs:complexType /></xs:element><xs:element name="Correo_Electronico"><xs:complexType /></xs:element><xs:element name="Documento_Identificacion"><xs:complexType><xs:sequence><xs:element ref="Numero" /></xs:sequence></xs:complexType></xs:element><xs:element name="Numero" type="xs:string" /><xs:element name="Datos_Especificos"><xs:complexType><xs:sequence><xs:element ref="datos" /></xs:sequence></xs:complexType></xs:element><xs:element name="datos"><xs:complexType><xs:sequence><xs:element ref="rbm" /></xs:sequence></xs:complexType></xs:element><xs:element name="rbm"><xs:complexType><xs:sequence><xs:element name="transaccion" type="transaccion"maxOccurs="unbounded" /></xs:sequence><xs:attribute name="identificadorLoteRbm" type="xs:int" use="required" /><xs:attribute name="fecha_envio" use="required"><xs:simpleType><xs:restriction base="xs:string"><xs:length value="8" /><xs:pattern value="[0-9]{8}" /></xs:restriction></xs:simpleType></xs:attribute></xs:complexType><xs:unique name="idReg"><xs:selector xpath="transaccion" /><xs:field xpath="

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center