Creating an NDATA Name Search Index On Binary Xml Column raises DRG-12605

(Doc ID 1560624.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Text - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Creating an NDATA name search index on binary xml column raises errors

Problem Description
---------------------------------------------------
exec ctx_ddl.create_section_group('test_namegroup','BASIC_SECTION_GROUP');
exec ctx_ddl.create_preference('test_nameds', 'MULTI_COLUMN_DATASTORE');
exec ctx_ddl.set_attribute('test_nameds', 'COLUMNS', 'xml_descriptors');
exec ctx_ddl.add_ndata_section('test_namegroup', 'xml_descriptors', 'xml_descriptors');

exec ctx_ddl.create_preference('namewl', 'BASIC_WORDLIST');
exec ctx_ddl.set_attribute('namewl', 'NDATA_THESAURUS', 'nicknames');

CREATE INDEX xml_test_name_ns ON test_name(xml_descriptors)
INDEXTYPE IS Ctxsys.Context
PARAMETERS('datastore test_nameds wordlist namewl section group test_namegroup sync(on commit)') ONLINE;

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 366

 

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