doubt in oracle text

[Shanmugam Karthikeyan]

Hi,


Hi i am getting a parse error when i tried to execute the following using catsearch.

>>> CATSEARCH (item_title,'{SIGN PEN SIGN R50 (M)), 12 PCS/BOX, RED}', null) > 0;

whereas when i use contains operator, there is no problem.

>>> contains (item_title,'{SIN PEN SIGN R50 (M)), 12 PCS/BOX, RED}') > 0;


Can anyone pls let me know the reason for this behaviour and also the solution for

this problem.

regards

S.Karthikeyan