CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work

[julochrobak]

Hi,

I need a help with ctxcat index on Oracle 10g. I need to improve searching using CTXCAT index. All is working quite well except SUBSTRING_INDEX parameter. I thought that following was necessary and sufficient:

EXEC ctx_ddl.create_preference('KEVFT_WL', 'BASIC_WORDLIST');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'substring_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_min_length', 1);
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_max_length', 6);

This BASIC_WORDLIST preference set is used for index creation. But the problem is, that when I try to search using query:

SELECT * FROM TMP_FULLTEXT
WHERE CATSEARCH(fulltext, '%abc', null)> 0;

then I get no rows in results. Despite the fact that row with the text 'aabc' exists in the table.
Can anyone tell me what the problem is?

Thank you,

Julius Chrobak

[julochrobak]

So, It seems like my problem is not solvable :(
Please if someone has any idea, any question or any help, please write it down.

I am still searching for the solution, but I am getting crazy :(

Thanx a lot for ANY help.


Julius Chrobak

[girirajdba]

I am not to sure but how could you give null in the where condition when null is a system generated value