Limit of AND in where clause ???

Using Oracle Forms 4.5.6 under Windows.

I have a pl/sql who did compile a while ago, but now since i added a "and 1 = 1 " to the where clause the program unit refuse to compile... It's give me an Program Error, but no error number... Any idea why ?

The select use in that pl/sql is about 2,6K in length.The where clause is about 100lines...

When I add a "and 1= 1" it just refuse to compile... But if I replace the AND by an OR, it compile :( I can keep adding alot of OR 1=1 and it still work.

So, is this cause by a maximun number of AND in a where clause under OracleForms ? (It work juste fine under SqlPlus3.1)

Is this a limit to the size of a select statement ?

Any help will be appreciated... Received on Fri Aug 18 1995 - 00:00:00 CEST