Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 1 2008
Added on Jun 27 2008
#database-key-features, #text
4 comments
4,020 views