From: jyu on
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