SQL Statement only seems to work over two lines in Oracle 8i

Dear all,

I have a weird one here that I am desperate to resolve (or might be me being stupid..not the first time).

I have an SQL statement, that basically errors, when run in code or in P/SQL. However if I put a neweline in the statement it then works....help :)

Not working version:

SELECT v_SearchCase.SocratesID from v_SearchCase,v_SearchScene,v_FlareDocket WHERE v_SearchCase.SocratesID = v_SearchScene.SocratesID(+) AND v_SearchScene.SceneID = v_FlareDocket.SceneID(+) AND (v_SearchCase.CrimeNum
= 'CRO32' OR v_SearchCase.CrimeNum LIKE 'CRE%');

This one does work

SELECT v_SearchCase.SocratesID from v_SearchCase,v_SearchScene,v_FlareDocket WHERE v_SearchCase.SocratesID = v_SearchScene.SocratesID(+) AND v_SearchScene.SceneID = v_FlareDocket.SceneID(+) AND (v_SearchCase.CrimeNum
= 'CRO32'

OR v_SearchCase.CrimeNum LIKE 'CRE%');

Any help would be great, as this SQL is build in code, and is used on other databases as well as oracle 8i. I can't start putting \n in the middle of the SQL,,,,,why does this happen.

Matt Received on Wed Aug 15 2001 - 03:08:55 CDT