OCIError: ORA-01795: maximum number of expressions in a list is 1000

[koskoci]

We get this error often when we use combine or aggregate in a rom-repository:
OCIError: ORA-01795: maximum number of expressions in a list is 1000
I believe this is because the above methods use subselects under the hood. Another option would be to use joins (eg. with wrap) but this is not feasible in our case.

Would it be possible to override this limitation of 1000 items in a list? Alternatively, is there a workaround you could suggest for this perhaps?

Your help would be much appreciated.

[koskoci]

Here is a SO answer about possible workarounds
https://stackoverflow.com/questions/17842453/is-there-a-workaround-for-ora-01795-maximum-number-of-expressions-in-a-list-is/32440238#32440238

[flash-gordon]

@koskoci yeah, all of them are rather ugly but we could slice ids into 1000-max lists and use multiple ORs. At the moment, I don't think there is anything except join