APEX

I have successful created an index using Oracle Text with Lateen characters in the English language

e.g.

create index sup_lang_eng_idx on SUPPLIER (SEARCH_ENG) indextype is ctxsys.context parameters('datastore ctxsys.default_datastore')

Works well

Now I need to do the same for Chinese characters in simplified Chinese

Reading the manuals it looks like I need to set the Lexer parameter i.e. chinese_lexer

e.g.

create index sup_lang_ch_idx on SUPPLIER (SEARCH_CH) indextype is ctxsys.context parameters('datastore ctxsys.default_datastore lexer CHINESE_LEXER')

I getting the following error message

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CHINESE_LEXER

I not sure what I am doing incorrectly ... is it a simple syntax error or am I going about this the wrong way?

All help very welcome

Regards

Pete