Oracle ORA-29902 Error!

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

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

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

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

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

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

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

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

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

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.

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

Mark

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