> Hi , iam getting this error because of the Oracle text issue. > and the solution is given as to rewrite the query .(i.e) to > reduce it to > below *256 bytes.* > > > > ORA-20000: Oracle Text error: > > DRG-50943: query token too long on line 1 on column 1 > > DRG-50943: query token too long on line 1 on column 1 > > ORA-06512: at "UNIVERSAL.BCOM", line 9989 > > ORA-06512: at line 1 > Is there any other way to fix this issue without rewriting the query.? Not the query in whole, but the oracle-text clause (contains(), about(),...) is the problem. Can you post the relevant code snipplet, e.g. the contains() clause? Martin -- //www.freelists.org/webpage/oracle-l