Re: Strange query - Oracle Text problems?

Your message subject is correct -- "Strange Query" -- but not in the way you are expecting.

Think about your where clause for a minute.

Oracle is expecting

where {column name} is NULL

you are changing it to

where {string literal} is null
(that is, not the FILE column that doesn't exist in your sample schema, but the letters 'file')

I don't believe this is what you are trying to ask. A more likely query is:
SELECT COUNT(*)
FROM FOO
WHERE search_col IS NULL OR CONTAINS(search_col,:the_filter) > 0;

with which I have had better luck.

If, for some reason, you are really trying to determine whether the user entered in one of your column names as their search expression, then you have a different problem with an entirely different approach -- one that doesn't have anything to do with Oracle Text. Received on Wed Nov 22 2006 - 12:45:16 CST