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

Last updated on APRIL 12, 2022

Applies to:

Symptoms

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  /
    begin
    *
    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

Cause

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