My Oracle Support Banner

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

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.5 to 9.2.0.6 [Release 9.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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 <Table Name>
(<Column 1> VARCHAR2(4) NOT NULL,
<Column 2> VARCHAR2(12) NOT NULL,
<Column 3> DATE NOT NULL,
<column 4> VARCHAR2(32) NOT NULL,
<Column 5> NUMBER(10) NOT NULL,
<Column 6> XMLType NOT NULL )
XMLTYPE COLUMN <Column 6> XMLSCHEMA "<Name>.xsd" ELEMENT "<Element Name>"

Cause

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
Symptoms
Cause
Solution

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