View Full Version : Problem with Special character in Oracle Text Manager
ganesh
12-07-2004, 08:58 PM
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
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.