Java.sql.sqlexception Ora-29902 Error In Executing Odciindexstart Routine
Contents |
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: Oracle/OAS Oracle ORA-29902
Ora-29902 Error In Executing Odciindexstart() Routine Ora-20000 Oracle Text Error
Error! Prabha Dhandapani Ranch Hand Posts: 70 posted 12 years ora-20000 oracle text error drg-50901 text query parser syntax error ago Hello everybody, Below is the query that I am trying to execute: SELECT score(1), ASSOC_ID,
Ora-06512: At Line 333
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 ora-13208 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 drg-51030: wildcard query expansion resulted in too many terms 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: ConT
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
29902. 00000 - "error In Executing Odciindexstart() Routine"
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ora-20000 oracle text error drg-10599 column is not indexed Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join
Oracle Contains
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, nm_e, https://coderanch.com/t/80327/Oracle-OAS/Oracle-ORA-Error 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 ,'xxstart http://stackoverflow.com/questions/26757387/ora-29902-error-in-executing-odciindexstart-routine-ora-20000-oracle-text-er 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, nm_a, nvl(sex, -1CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not https://community.oracle.com/thread/354449 work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Spatial All PlacesDatabaseOracle Database + OptionsSpatial This discussion is error in archived 1 Reply Latest reply on Jan 11, 2006 1:48 PM by 10275 ORA-29902, ORA-13203,ORA-29400 440705 Jan 6, 2006 5:38 PM I hope someone can help. I am querying spatial data through mapviewer but sometimes I get a whole bunch of errors (see below) whilst error in executing othertimes the same tables etc are fine. We are only working with a tiny amount of data as this is a development db. When running on OC4J standalone we did not recieve these errors, only since we have installed on the application server do we receive them. Any help greatly appriciated. TIA Chris 06/01/06 17:26:31 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: WATER 06/01/06 17:26:31 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-29400: data cartridge error ORA-04031: unable to allocate 76 bytes of shared memory ("shared pool","SELECT diminfo, nvl(srid,-1)...","Typecheck","qksxaAddList:xa") ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2973) at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindo