Text Search error: oci_execute(): ORA-29902

From: jyu <jyu_at_mpr.org>
Date: Mon, 5 Feb 2007 15:18:26 -0600
Message-ID: <45c79f22$0$15004$8046368a@newsreader.iphouse.net>

Hi,

I got a ORA-29902 error when I tried to execute the following SQL through a php program. "contact" is the parent table of "domain_conatct" and the foreign key is dcon_con_id and "con_text" is a text index column in the "contact" table. I have Oracle 10g version 2.

SQL: SELECT count(*) FROM contact,domain_contact WHERE (dcon_con_id = con_id ) AND ((contains(con_text, '%John% within con_first_name') > 0) AND (con_rec_status = 'A') AND (dcon_dom_id in (7))) GROUP BY con_id, con_last_name, con_first_name

PHP Warning: oci_execute(): ORA-20000: Oracle Text error:

DRG-00100: internal error, arguments : [50935],[drpn.c],[992],[],[]
DRG-00100: internal error, arguments : [50935],[drpnw.c],[600],[],[]
DRG-00100: internal error, arguments : [51002],[drwa.c],[573],[],[]
DRG-00100: internal error, arguments : [51028],[drwaw.c],[306],[0],[%JOHN%]
DRG-00100: internal error, arguments : [50401],[dreb.c],[1037],[],[]
ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], 

[], []

 in /opt/mysql/php/lib/oracle_db_func.inc on line 154

Warning: oci_execute(): ORA-20000: Oracle Text error:

DRG-00100: internal error, arguments : [50935],[drpn.c],[992],[],[]
DRG-00100: internal error, arguments : [50935],[drpnw.c],[600],[],[]
DRG-00100: internal error, arguments : [51002],[drwa.c],[573],[],[]
DRG-00100: internal error, arguments : [51028],[drwaw.c],[306],[0],[%JOHN%]
DRG-00100: internal error, arguments : [50401],[dreb.c],[1037],[],[]
ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], 

[], []

 in /opt/mysql/php/lib/oracle_db_func.inc on line 154

I tried the SQL from the Oracle web client iSQLPlus, no errors. So seems there are some issues at the connection between PHP and Oracle. Also, if I removed the right "%" from the contains clauses, then the SQL was executed without any errors.

Can someone help me out with this issue? Thanks a lot.

Jinzhu Received on Mon Feb 05 2007 - 15:18:26 CST