XML Schema registration fails with ORA-30937: No schema definition for 'assert' (Doc ID 1599364.1)

Last updated on APRIL 12, 2022

Applies to:

Symptoms

Registering a XML schema fails with:

SQL> declare
 2     l_xml xmltype;
 3     begin
 4       l_xml := xmltype(bfilename('XML_DIR','Testnalysis.xsd'), nls_charset
_id('UTF8'));
 5  dbms_xmlschema.registerschema(SCHEMAURL =>'http://myxschema.com/TestAnalysis.xsd',schemaDoc => l_xml,options => dbms_xmlschema.REGISTER_BINARYXML,genTypes
=> false);
 6  end;
 7  /
declare
*
ERROR at line 1:
ORA-30937: No schema definition for 'assert' (namespace
'http://www.w3.org/2001/XMLSchema') in parent '/schema/element[2]/complexType'
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 55
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 159
ORA-06512: at line 5

Cause

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