Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CATSEARCH only works with AND not with Or

438019Jun 27 2008 — edited Jul 4 2008

Hello,

If I run the following query against my database it runs absolutely fine
SELECT * FROM
LOAD
WHERE ((catsearch (WILDCARD_SURNAMES, 'BRUCE', '') > 0)) AND PARSED_FORENAME1='ANTHONY'

But if I replace the "AND" with an "OR"
SELECT * FROM
LOAD
WHERE ((catsearch (WILDCARD_SURNAMES, 'BRUCE', '') > 0)) OR PARSED_FORENAME1='ANTHONY'
I get an Oracle error
ORA-20000: Oracle Text error:
DRG-10849: catsearch does not support functional invocation
DRG-10599: column is not indexed

I don't understand this, why can't I use OR?
Thanks for any help
Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2008

Added on Jun 27 2008

#database-key-features, #text

4 comments

4,077 views