My Oracle Support Banner

ORA-30756 Registering an XML Schema that References Another Schema (Doc ID 315894.1)

Last updated on APRIL 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
Oracle XML DB (XDB)


Registering a schema that references another XML schema (XSD) fails with errors:

   SQL> begin
      2    dbms_xmlschema.registerschema(
      3    'person.xsd',
      4    getdocument('oracle.xsd'),
      5    true,
      6    true,
      7    false,
      8    true);
      9  end;
     10  /
    ERROR at line 1:
    ORA-31084: error while creating table "test"."oracle168_TAB" for element "employee"
    ORA-30756: cannot create column or table of type that contains a supertype attribute
    ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 17
    ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 26
    ORA-06512: at line 2


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.