Problem with Special character in Oracle Text Manager
Date: 7 Dec 2004 20:58:26 -0800
Message-ID: <ee96a318.0412072058.62ac717b_at_posting.google.com>
Dear folks,
I am using Oracle Text Manager for full text search and synonym search.
To escape a special character }, }} is used. It is working fine for Fuzzy and Phonetic search but not for Synonym search.
My query is
SELECT NAME,SCORE(1) FROM DRUG
WHERE CONTAINS(NAME,'SYN(A}}B,SYNONYM_LIST)',1) > 0;
If i execute the above query, an Oracle parsing error occured. I am
doing the above the above test to validate the search query given by
the user.
The term A}B is defined in the Thesaurus called synonym_list as
A}B
UF FEVER
UF COLD
Executing the following query also returns same error, since Fever is
a synonym of A}B.
SELECT NAME,SCORE(1) FROM DRUG
WHERE CONTAINS(NAME,'SYN(Fever,SYNONYM_LIST)',1) > 0;
How to avoid this situitation.
Any help will be appreciated.
Regards
gAnesh
Received on Wed Dec 08 2004 - 05:58:26 CET