Is there any way I can combine two CATSEARCH in a single query?
]]>lkngstr82is2010-10-13T23:26:26-00:00Re: Searching using CATSEARCH and ORhttp://www.orafaq.com/forum/./mv/msg/162409/478980/#msg_478980
There should not be a space between the single quotes around the third parameter of the catsearch operator. It should be a null value, so either use two single quotes without a space or the word null.

There is also a problem with ctxcat indexes and catsearch where the optimizer may choose functional invocation at any time, which will always produce an error without returning any rows. This is why I always recommend context indexes and contains.

If you are querying two columns, then it is better to use a context index with a multi_column_datastore and use one contains clause. If you want to search within specific columns, then you can add a section group with field sections and use within clauses within one contains clause. It is generally a bad practice to use multiple catsearch or contains clauses in one query.

If your second column is purely structured data like numbers or dates, then you can create a ctxcat index with a sub-index, but this still does not solve the functional invocation problem.

I have corrected your code below, then offered a better method below that.