Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ConText error when searching on "NT"

ConText error when searching on "NT"

From: <JonnyA_at_my-dejanews.com>
Date: Thu, 13 Aug 1998 19:46:08 GMT
Message-ID: <6qvfq2$nih$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US