Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ConText error when searching on "NT"
We are getting a "Syntax Error" from ConText whenever the term "NT" appears in
our search clause. The search works fine when we place NT in curly braces, but
it won't take it without, either as part of another phrase, or on its own. Is
this an undocumented reserved word, or is Oracle trying to prevent searches on
Microsoft technology? :)
The following SQL statement returns an error:
......
SELECT ID, SCORE(1)
FROM CU_DOCUMENTS
WHERE CONTAINS(CU_CHART, 'nt', 1) > 0
......
The error it returns is:
......
ERROR:
ORA-00604: error occurred at recursive SQL level 1 ORA-20000: ConText error: DRG-10801: text query failed DRG-50901: text query parser syntax error on line 1, column 3 ORA-06512: at "CTXSYS.DRUE", line 180 ORA-06512: at "CTXSYS.DR_REWRITE", line 408 ORA-06512: at line 1
The following SQL statement works fine:
......
SELECT ID, SCORE(1)
FROM CU_DOCUMENTS
WHERE CONTAINS(CU_CHART, '{nt}', 1) > 0
......
Any ideas?
Thanks for your time.
-Jon.
--
Jon Atkinson * Senior Developer * Virtual Frontiers
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 14:46:08 CDT
![]() |
![]() |