Problem with Special character in Oracle Text Manager

From: ganesh <geek_ganesh_at_hotmail.com>
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

Original text of this message