Hi

I used to think that Oracle query-statements cannot exceed about 5,000 characters. I had defined a query containing almost 13,000 (!) characters with LLBLGen (a huge filterBucket), and I found out that it worked fine.

What am I missing?

It might be that limit was on older oracle versions?

Btw, a query of 13KB, that's pretty huge . You defined a large range predicate?

At first I had a simple FieldCompareSetPredicate with two sub-selects with an OR in the middle, so in order to check the length issue I added the same sub-selects...not very smart I agree, but allowing to check the length issue.

I am now working with Oracle 10g, maybe that's why I had no problems with my large query?

I'm not aware of a query length limit, so it should be ok