Drg-50901 Text Query Parser Syntax Error
Contents |
Mon, 01 June 2009 07:46 navkrish Messages: 189Registered: May 2006 Location: NJ,USA Senior Member All, I have table T1 with column tc1. Tc1 has a domain index on it. CREATE ora-20000 oracle text error drg-50901 text query parser syntax error INDEX t1_ID1 ON T1 (tc1) INDEXTYPE IS CTXSYS.CONTEXT; For certain words, if I
Ora-29902: Error In Executing Odciindexstart() Routine
do a search I get below error: SQL> SELECT count(*) 2 FROM T1 3 WHERE contains (tc1, 'NTI') >
Ora-29902 Error In Executing Odciindexstart() Routine Ora-20000 Oracle Text Error
0; SELECT count(*) * ERROR at line 1: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 4 Any idea? Thanks,
Drg-51030: Wildcard Query Expansion Resulted In Too Many Terms
NavKrish Report message to a moderator Re: Oracle Text error [message #406000 is a reply to message #405992] Mon, 01 June 2009 08:47 Michel Cadot Messages: 63853Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator DRG-50901: text query parser syntax error on line %(1)s, column %(2)s *Cause: bad query *Action: fix query *Mnemonic: PE_SYNTAX Regards Michel Report message to a ora-13208 moderator Re: Oracle Text error [message #406008 is a reply to message #406000] Mon, 01 June 2009 10:08 Barbara Boehmer Messages: 8601Registered: November 2002 Location: California, USA Senior Member Any time that you try to search for a word that has special meaning to Oracle Text or a stopword or some such thing, without escaping it, you are likely to get a syntax error. "NTI" has special meaning to Oracle Text, as documented here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqoper.htm#sthref1132 You can find a list of such words here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqspcl.htm#sthref1319 So, you need to escape it, as documented here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqspcl.htm#sthref1309 Please see the demonstration below, that first reproducers the error, then corrects it by using curly brackets to escape the special word. SCOTT@orcl_11g> CREATE TABLE t1 (tc1 VARCHAR2(30)) 2 / Table created. SCOTT@orcl_11g> INSERT INTO t1 VALUES ('NTI') 2 / 1 row created. SCOTT@orcl_11g> CREATE INDEX t1_id1 ON t1 (tc1) INDEXTYPE IS CTXSYS.CONTEXT 2 / Index created. SCOTT@orcl_11g> SELECT * FROM t1 WHERE CONTAINS (tc1, 'NTI') > 0 2 / SELECT * FROM t1 WHERE CONTAINS (tc1, 'NTI') > 0 * ERROR at line 1: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Or
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! ora-06512: at line 333 Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson 29902. 00000 - "error in executing odciindexstart() routine" Blog
ORA-29902: Error in Executing ora-20000 oracle text error drg-50857 ODCIIndexStart() Routine Oracle Database Tips by Burleson Consulting May 1, 2016 Question: We have been getting ORA-29902 errors from certain queries against some Oracle 9.2.0.6 databases http://www.orafaq.com/forum/t/145890/ with Oracle Text. A good example of our queries is shown as follows: SELECT r.id, r.parentid, r.name FROM assetrefs r INNER JOIN FullTextStrings s ON s.assetid = r.id AND CONTAINS( s.val, 'anyword', 1 ) > 0 WHERE r.parentid = '{583503FF-67E7-431E-93F8-382CCA65F9C5}'; The complete error message is shown as follows: 11/16/07 01:19:35 http://www.dba-oracle.com/t_ora_29902_error_in_executing_odciindexstart_routine.htm ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 1 State:S1000,Native:29902,Origin:[Oracle][ODBC][Ora] Now, the tricky things about the error are: The error happens ONLY when the parameter for Oracle Text, 'anyword', is passed in by our application via dynamic parameter binding. If we don't use dynamic binding for that parameter, the query runs well and returns correct results. The error happens no matter what 'anyword' is. Dynamic parameter binding for the parameter in the non-Oracle-Text constraint, r.parentid = '{583503FF-67E7-431E-93F8-382CCA65F9C5}', does NOT incur any error. The error always happens to some Oracle database instances but never happened to other instances. Based on the observation described above, we suspected that our error problem is related to the configuration and/or environment of Oracle Text. Does anyone out there have any idea about what's wrong with the configuration/environment? Any idea how to fix the problem? Answer: To diagnose any erLibrary mySQL Code Library PHP Code Library https://www.experts-exchange.com/questions/26896563/Oracle-indexes-and-selects-with-special-characters-give-ORA-29902.html JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs ora-20000 oracle Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us ora-20000 oracle text Oracle Error: DRG-50901 Error Description: Text query parser syntax error on line string, column string Error Cause: Bad query. Action: Fix query. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 64 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle indexes and selects with special characters give ORA-29902 Want to Advertise Here? Solved Oracle indexes and selects with special characters give ORA-29902 Posted on 2011-03-18 Oracle Database 1 Verified Solution 25 Comments 3,028 Views Last Modified: 2013-12-07 Hi, I need help to build the correct index for a table. Simplified scenario - we have MySchema.MyTable - MyTable has an index on the field PRODUCT_DESCR, which is a VARCHAR2(2000) field. The index is: CREATE INDEX MYSCHEMA.IDX_PRODUCT_DESCR ON MYSCHEMA.MYTABLE (PRODUCT_DESCR) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('SYNC(ON COMMIT)') NOPARALLEL; - the following select: SELECT * FROM MyTable WHERE CONTAINS( PRODUCT_DESCR, '%shoes*%', 1) > 0 leads to this error: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 6 - the following select: select * from MyTable where contains( short_desc, '%sko,%', 1)>0 leads to this error: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-51030: wildcard query expansion resulted in too many terms ORA-06512 Question How should I modify IDX_PRODUCT_DESCR so that the selects above work correctly? A stupid question maybe, but I am newbie in PL/SQL, and index seems difficult to me. Thank you in advance. 0 Question by:kathysmith Facebook Twitter LinkedIn Google LVL 75 Active today Best Solution bysli