My Oracle Support Banner

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

Last updated on APRIL 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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
 5  dbms_xmlschema.registerschema(SCHEMAURL =>'',schemaDoc => l_xml,options => dbms_xmlschema.REGISTER_BINARYXML,genTypes
=> false);
 6  end;
 7  /
ERROR at line 1:
ORA-30937: No schema definition for 'assert' (namespace
'') 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


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.