Hi,
We have created a ctxcat index over a column. If we run this query
select * from table where CATSEARCH(indexed column, 'foo' , null)>0;
works fine, but if we run
select * from table where CATSEARCH(indexed column, 'foo' , 'order by indexed column')>0;
oracle returns an error. This error says that the column is not indexed.
ORA-29902: error al ejecutar la rutina ODCIIndexStart()
ORA-20000: Oracle Text error:
DRG-10844: el índice no puede ejecutar este predicado estructurado de forma eficaz
DRG-10845: la columna NOMBRE no está indexada
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.
Best regards,
Jaime