My Oracle Support Banner

Text Index on Multi_Column_Datastore involving XMLType data column fails with DRG-12605 (Doc ID 357311.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Text - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2010***


Symptoms

Creating a text index using the multi-column datastore where at least one column's an XMLType fails in SQL*Plus with an errorstack including:

DRG-12605: datatype of column 1 in COLUMNS list is not supported

To reproduce:

SQL> create table tst(
     2   id number,
     3   HEADER_XML XMLTYPE,
     4   DCMNT_BODY_XML XMLTYPE,
     5   DCMNT_BODY_CLOB CLOB,
     6   dummy char(1));

Table created.

SQL> begin
     2   ctx_ddl.create_preference('MULTI_DST','MULTI_COLUMN_DATASTORE');
     3   ctx_ddl.set_attribute('MULTI_DST', 'columns','header_xml, dcmnt_body_xml, dcmnt_body_clob');
     4   end;
     5   /

PL/SQL procedure successfully completed.

SQL> begin
     2   ctx_ddl.create_section_group('MULTI_SGP','NULL_SECTION_GROUP');
     3   end;
     4   /

PL/SQL procedure successfully completed.

SQL> create index MULTI_INDEX
     2   on TST (dummy)
     3   indextype is ctxsys.context
     4   parameters('
     5   datastore MULTI_DST
     6   section group MULTI_SGP')
     7   /
create index MULTI_INDEX
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12605: datatype of column 1 in COLUMNS list is not supported
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

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
References

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