Error Code 50901

CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled.

Ora-20000 Oracle Text Error Drg-50901 Text Query Parser Syntax Error

Please turn JavaScript back on and reload this page. Please ora-29902: error in executing odciindexstart() routine enter a title. You can not post a blank message. Please type your message and ora-29902 error in executing odciindexstart() routine ora-20000 oracle text error try again. More discussions in Text All PlacesDatabaseOracle Database + OptionsText This discussion is archived 5 Replies Latest reply on Apr 29, 2016 6:51 PM

Ora-06512: At "mdsys.sdo_index_method_10i", Line 333

by Roger Ford-Oracle Oracle Text error: DRG-50901: text query parser syntax error Chintan Gandhi Apr 28, 2016 11:12 PM Hi,I am on Oracle 11gR2. I have a text index created on my table column, and when I am passing parameter as comma (,) or semicolon (;), etc. it gives me

Ora-13208

error Oracle Text error: DRG-50901: text query parser syntax error.I know a solution is to escape these characters using '\', but this search string is entered by user and I don't know what all characters, I need to escape. Can anyone help me on how to escape all the reserved characters?Code: CREATE TABLE MY_LOGS ( job_id NUMBER, log_program VARCHAR2(100), log_parameters VARCHAR2(2000), search_logs_flag VARCHAR2(1) );CREATE OR REPLACE TRIGGER BIU_MY_LOGS before insert OR UPDATE on MY_LOGS for each rowbegin :NEW.SEARCH_LOGS_FLAG := 'Y';end;/ -- create preferences ctx_ddl.create_preference('MY_LEXER','BASIC_LEXER'); ctx_ddl.set_attribute('MY_LEXER', 'printjoins', '-_'); ctx_ddl.create_preference('MULTI_SEARCH_LOGS','MULTI_COLUMN_DATASTORE'); ctx_ddl.set_attribute('MULTI_SEARCH_LOGS', 'columns', 'job_id, log_program, log_parameters'); -- create text indexes CREATE INDEX MY_LOGS_CTX1 ON MY_LOGS (SEARCH_LOGS_FLAG) INDEXTYPE IS ctxsys.context PARAMETERS ('DATASTORE MULTI_SEARCH_LOGS sync (on commit) LEXER my_lexer');-- Query that gives mentioned error isSELECT * FROM MY_LOGS where CONTAINS (SEARCH_LOGS_FLAG, ',', 1) > 0Thanks. I have the same question Show 0 Likes(0) 636Views Tags: none (add) drg-50901Content tagged with drg-50901, oracle_t

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about examine the error messages produced by the indextype code and take appropriate action. hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges

Drg-51030: Wildcard Query Expansion Resulted In Too Many Terms

Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. ora-20000 oracle text error drg-50857 Join them; it only takes a minute: Sign up ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 19 up vote 0 down vote favorite SELECT person_no sub_sys_individual_id, https://community.oracle.com/thread/3924573 nm_e, nm_a, nvl(sex, -1) sex, nvl(prs_nat, -999) prs_nat, person_no, 'NA' prog_where_not_allowed, 'NA' udb_no, person_tp, pass_no FROM ban_inq_tab WHERE contains (nm_e ,'xxstart JUHETI BT MEMED ASMANI%') >0 AND (trans_flag IS NULL OR trans_flag = 'C'); please help me in this issue and getting parser syntax error oracle text share|improve this question edited Nov 5 '14 at 14:43 mmmmmpie 1,4651819 asked Nov 5 '14 at 12:36 Francis John 2928 Does the query work without this: WHERE contains (nm_e http://stackoverflow.com/questions/26757387/ora-29902-error-in-executing-odciindexstart-routine-ora-20000-oracle-text-er ,'xxstart JUHETI BT MEMED ASMANI%') >0 –mmmmmpie Nov 5 '14 at 14:18 yes query is working fine without contains. Help me in handling this reseved word BT –Francis John Nov 6 '14 at 5:33 Its look like OracleText index error –Max Kvt May 7 '15 at 6:50 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The error is causing the BT, which is a reserved word. The solution is described in the Oracle Community forum. share|improve this answer answered Nov 5 '14 at 14:25 mikron 58369 Thanks Mike, In that post they mentioned that putting curly braces {} will solve the issue. But for me now after putting {} no rows returned from the query. –Francis John Nov 6 '14 at 5:31 Help me in handling this reserved word BT –Francis John Nov 6 '14 at 5:34 Try to replace the reserved word BT (Broader Term) with the escape character /. Your search string would be like

where contains (oratext ,'xxstart JUHETI /BT MEMED ASMANI%') >0 . Also You can read more on the oracle documentation on the oracle text contains query operator –mikron Nov 6 '14 at 6:34 add a comment| up vote 0 down vote You must escape the BT special word (but you can just escape the entire string). SELECT person_no sub_sys_individual_id, nm_e,
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support  Development  Implementation Consulting StaffConsulting http://www.dba-oracle.com/t_ora_29902_error_in_executing_odciindexstart_routine.htm PricesHelp Wanted!  Oracle PostersOracle Books Oracle Scripts Ion Excel-DB https://coderanch.com/t/80327/Oracle-OAS/Oracle-ORA-Error  Don Burleson Blog    
         ORA-29902: Error in Executing ODCIIndexStart() Routine Oracle Database Tips by Burleson Consulting May 1, 2016 Question: We have been getting ORA-29902 errors from certain queries ora-20000 oracle against some Oracle 9.2.0.6 databases 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 ora-20000 oracle text is shown as follows: 
 11/16/07 01:19:35 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
This Site Careers Other all forums Forum: Oracle/OAS Oracle ORA-29902 Error!  Prabha Dhandapani Ranch Hand Posts: 70 posted 12 years ago  Hello everybody, Below is the query that I  am trying to execute: SELECT score(1), ASSOC_ID, ASSOC_WORD_ROOT, ASSOC_WORD_ALTERNATE FROM ASSOC_WORD WHERE CONTAINS(ASSOC_WORD_ALTERNATE,  'Fuzzy(OR,60,100)' , 1) > 0 order by score(1) desc in the above query, 'OR'is the ASSOC_WORD_ALTERNATE for "Operating  Room"-ASSOC_WORD_ROOT in the table.When I execute the above query, i get the following error: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on  line 1, column 7 Can somebody help me out with this.I browsed the net for some help but could not find anything useful.Please rescue me Ranchers!This is very very urgent and important to me! Many Thanks in advance, Prabha  Mark Spritzler ranger Sheriff Posts: 17278 6 I like... posted 12 years ago While this might not be your specific problem.  It appears that there was a bug in Oracle not some time ago and that might be your issue. Here is a document from Metalink. If you do a query on your ORA-29902 you will find lots of documents like this one to help out. Doc ID: Note:105851.1 Subject: Problem/Solution: ORA-29902 DRG-50857 ORA-904 ORA-30576 after upgrade to 8.1.6 Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 19-APR-2000 Last Revision Date: 19-JUL-2002 Problem Description ------------------- After upgrading the RDBMS from 8.1.5 to 8.1.6 the following errors may occur when performing a 'select .. where contains ..' on a table which has been indexed using InterMedia: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: interMedia Text error: DRG-50857: oracle error in drdmlpo ORA-00904: invalid column name ORA-30576: ConText Option dictionary loading error Solution Description -------------------- Verify which text version is currently installed, connected as CTXSYS: SQL> select * from ctx_version; gives you the installed ctxsys-version. Run the following upgrade scripts when version is 8.1.5: $ORACLE_HOME/ctx/admin/upgrade/u0801060.sql as user CTXSYS $ORACLE_HOME/ctx/admin/upgrade/s0801060.sql as user SYS $ORACLE_HOME/ctx/admin/dr0pkh.sql as user CTXSYS $ORACLE_HOME/ctx/admin/dr0plb.sql as user CTXSYS $ORACLE_HOME/ctx/admin/dr0type.plb as user CTXSYS Explanatio