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.* Is there any other way to fix this issue without rewriting the query.? 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 Regards, Mohammed Mehraj Hussain