My Oracle Support Banner

Are EBR enabled XML schemas supported? (Doc ID 2467251.1)

Last updated on NOVEMBER 10, 2019

Applies to:

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

Goal

Are Editioned Based Redefinition (EBR) based objects supported for registration of XML Schemas?

Attempts to register an xmlschema fails with:

SQL> BEGIN
 DBMS_XMLSCHEMA.registerSchema(
  SCHEMAURL => '<schema url>',
  SCHEMADOC => bfilename('XSD_DIR','FSAFeedCommon-v1-2.xsd'),
  LOCAL => TRUE,
  GENTYPES => TRUE,
  GENTABLES => TRUE);
END;
/
 2 3 4 5 6 7 8 9 BEGIN
*
ERROR at line 1:
ORA-31084: error while creating table "<owner>"."<table>" for element "CoreItems"
ORA-38818: illegal reference to editioned object <owner>.<table>
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136
ORA-06512: at line 2


 

Solution

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
Goal
Solution


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