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

Last updated on SEPTEMBER 03, 2010

Applies to:

Oracle Text - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.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

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