Hi,
I use Context index for the search.
The query :
SELECT * FROM S_ARTICLE WHERE CONTAINS(ORATEXT,'BT-50')>0
The problem is that BT is reserved word for Contains ....Broader Term ... and therefor I get
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 3
I read that putting BT like {BT} would work .... but the problem is that I don't know what the user will type in ... query is created dynamicaly so I
never know what is user typing I just put it inside CONTAINS ... and I would preffer to have it like this :)
I tried to write queries like " CONTAINS(ORATEXT,'{BT-50 GOOD BREAD}' .... so putting the whole search phrase in brackets .... and it looks like it works ....
So I would just like to get some confirmation from you guys, that this is actually correct ... if not then please correct me and please give me some example of how to do it better and correct.
Thank you,
Kris