aspose file tools*
The moose likes Oracle/OAS and the fly likes Oracle ORA-29902 Error! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle ORA-29902 Error!" Watch "Oracle ORA-29902 Error!" New topic
Author

Oracle ORA-29902 Error!

Prabha Dhandapani
Ranch Hand

Joined: Sep 11, 2003
Posts: 70
Hello everybody,
Below is the query that I am trying to execute:

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

Joined: Feb 05, 2001
Posts: 17257
    
    6

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 Explanation ----------- After upgrading the RDBMS from 8.1.5 to 8.1.6, the ctxsys schema has to be upgraded as well. Related Documents Please also review [NOTE:73605.1] Which covers manual Install issues. Please also review [NOTE:120611.1] for an upgrade to 8.1.7. Additional Search Words ----------------------- CTXSYS, 8.1.5, 8.1.6, interMedia Text, DRGEN

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Prabha Dhandapani
Ranch Hand

Joined: Sep 11, 2003
Posts: 70
Hello Mark,
Thanks for the help but now my query seems to return nothing.Below is the query:


the above query was returning results 2 days ago, but now it is says "no rows selected"
but the below search works :


can u tell me the reason.could it be because of data population?please help me!
Thanks,
Prabha
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

Unfortunately, I have no experience with the CONTAINS and SCORE keywords and how they work. I'd check your parameters of the CONTAINS function. Maybe the 1 at the end should be a 0. I am assuming that number represents the beginning character. And if Oracle is 0 based, then 1 starts at the second character instead of the first, and therefore not matching to the second queries where clause.
I wish I could help more. Sorry.
Mark
Prabha Dhandapani
Ranch Hand

Joined: Sep 11, 2003
Posts: 70
Hey Mark,
Thanks a lot!I got the issue solved.I made a mistake in the syntax The syntax for Contains and fuzzy:

hope this might help somebody working on 'search'!!!
Mark,Can you tell me how to edit a stored procedure in TOAD???
Cheers,
Prabha
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

Well in Toad, you have the Schema Browser. It has tabs for all different database objects. Well there is a tab for "procs". In this area is a tree object, that has procedures, functions and packages. If you want to edit a procedure click the "+" sign to open and list all the procedures. If you select one of them and right click, there is a "Load In Procedure Editor" selection. This will load the procedure into the esditor that will allow you to edit, compile, debug and run your procedures. You need to put your cursor over the buttons in the toolbars to find out what the buttons do. But the one button with a Lightning Bolt is used to run a procedure. The button next to it with the "(...)" on it is to set values for the parameters in debug mode.
You really should read the help or a manual to get some more info on dealing with editing and debuging procedures etc in Toad.
Hope that helps you a bit.
Mark
Prabha Dhandapani
Ranch Hand

Joined: Sep 11, 2003
Posts: 70
Thanks Mark! I got to the tree but I was not in the right tree...the tree that had no procedures but just +procedures ...Got it now!!!
Thanks,
Prabha
Gaurav Malik
Greenhorn

Joined: Feb 24, 2003
Posts: 3
If you are encountering error
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 38

This appears one of the oracle text keyword is part of your search name
like BT, PT, SYN etc
toan voduc
Greenhorn

Joined: Jul 06, 2005
Posts: 1
Hello every body!
I have some problem like Prabha. When I am trying to execute:
---- code ---
SELECT * FROM resource_view
WHERE under_path(RES,'/public/home/') > 0
AND contains(RES,'=') > 0
----
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 1

Is the error different from error Prabha got?
Can Mr.Mark Spritzler help me out with this.
Thanks,
voduc

Tom Battaglia
Greenhorn

Joined: Jul 08, 2005
Posts: 8

Originally posted by toan voduc:
Hello every body!
I have some problem like Prabha. When I am trying to execute:
---- code ---
SELECT * FROM resource_view
WHERE under_path(RES,'/public/home/') > 0
AND contains(RES,'=') > 0
----
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 1

Is the error different from error Prabha got?
Can Mr.Mark Spritzler help me out with this.
Thanks,
voduc




I have noticed this error repeatedly when reserved (for Intermedia searches) words or characters are used in the query. Whenever I remove them before executing the query, the errors cease.


---<br />Tom Battaglia<br />:wq
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

From the previous problem above, it appeared to be the syntax of the contains procedure call.

Mark
Shanmugam Karthikeyan
Ranch Hand

Joined: Aug 02, 2002
Posts: 58
Hi,

I am getting the following error while using the catsearch of oracle text.

ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 47
ORA-06512: at "PROC_GMALL_PC_MASK", line 123
ORA-06512: at line 2

I am using catsearch in my stored procedure as

CATSEARCH (item_title,C2.ITEM_DESCRIPTION, null) > 0)

I am getting this parser problem when the C2.ITEM_DESCRIPTION value is either of the following values.

1. " SIGN PEN SIGN PEN - BALL LINER, PENTEL R50 (M)), 12 PCS/BOX, RED "
2. " PVC MAGAZINE HOLDERS (4")"

I think the above lines has some oracle text keywords which is creating this parser problem.

Can anyone pls tell me know a solution for this problem.


regards


SCJP 1.4<br />SCWCD 1.4<br />SCBCD 1.3
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle ORA-29902 Error!