ORA-00920 invalid relational operator

Hello evry body

I have a very strange problem, the following query raise an exception when executed from Java (JDBC) but is successfully executed within TOAD.

SELECT e.region, e.subregion, e.holding, e.id, e.deleted,

       e.id_mergefile id_frf, t.sizeclass, t.subdivision  FROM r1_typology t, r1_farmreturn_entry e  WHERE id_entry = id AND id_mergefile=1392 AND id_basefile IS NOT NULL AND t.sgmversion = 1996 AND t.typologyversion = 1996393 AND e.region||'.'||e.subregion||'.'||e.holding LIKE '%.24.%' ORDER BY e.region, e.subregion, e.holding

I guess the problem come from the
[e.region||'.'||e.subregion||'.'||e.holding LIKE '%.24.%'] part but I need it and I don't know how to correct it. Could you help me ?

Olivier Received on Mon Jul 04 2005 - 08:01:07 CDT