Re: Limit of AND in where clause ???

In <410h0r$972_at_volcano.jrv.qc.ca> barrette_at_jrv.qc.ca (Alain Barrette) writes:
>
>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...
>
>
Please liet us know the complete select statement.

thanks Received on Mon Aug 21 1995 - 00:00:00 CEST