ora-600 [17092] Impossible To Create Xmltype Column Based On Registered Xml-Schema (Doc ID 336312.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 9.2.0.6 - Release: 9.2 to 9.2
Information in this document applies to any platform.

Symptoms

The following internal error is generated during CREATE TABLE with user defined types (XML):
      ORA-00600: internal error code, arguments: [17092], [0x3879EC260], [], [], [], [], [], []

In the trace file is reported:

- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
3869c5fc0         0  package XDB.DBMS_XMLSCHEMA_INT
3869c59b8        26  package body XDB.DBMS_XMLSCHEMA
3869c59b8       131  package body XDB.DBMS_XMLSCHEMA
388963b28        34  anonymous block

- call stack: .. kgludp qmtsTableAddDepende qmtsPhase2 qmtsCompileSchemaXo qmtsclob qmtslrsl spefcmpa ..

The failing statement is:

CREATE TABLE BDB_LOCATIES
(GEM_CODE    VARCHAR2(4) NOT NULL,
LOC_CODE    VARCHAR2(12) NOT NULL,
DT_MUTATIE  DATE NOT NULL,
USR_MUTATIE VARCHAR2(32) NOT NULL,
NR_UITGAVE  NUMBER(10) NOT NULL,
LOC         XMLType NOT NULL )
XMLTYPE COLUMN LOC XMLSCHEMA "sheet.xsd" ELEMENT "locatie"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms