Re: Oracle Text error

  • From: "Martin Busik" <martin.busik@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 May 2009 10:55:19 +0200

> 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


Other related posts: