problem is when I type the word 'All' and I have a string which contains this word in the beginning

Hi,

I'm using Oracle text for my global search in my application.

Behind the search engine I'm using a materialized view with Oracle text index which uses a LEXER:

BEGIN

CTX_DDL.CREATE_PREFERENCE('MYLEX', 'BASIC_LEXER');

CTX_DDL.SET_ATTRIBUTE('MYLEX', 'PRINTJOINS', '_-%()');

END;

/

CREATE INDEX

    ENTITY_FULL_TREE_TXTIX1

ON

    ENTITY_FULL_TREE_MV1

    (

        FULL_PATH

    )

    INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS

    (

        'LEXER MYLEX'

    ) ;

The search procedure is retrieving a free text and search it within the materialized view using CONTAINS.

The problem is when I type the word 'All' and I have a string which contains this word in the beginning of a word, it doesn't find it.