SQL & PL/SQL

Hi All,

I am using Oracle 11.2, and having DRG-10599 error when I used contains and have ctxsys.context index as following:

create table tb_nm
(
nm varchar2(32) ,
addr clob
);

create index idx_addr on tb_nm(addr) indextype is ctxsys.context
parameters('storage idx_addr lexer TEXT_LEXER sync(on commit)');

select * from tb_nm where contains(addr, 'how are')>0;

Any suggestion?

Thanks!