ActiveRecord 2.3.3 in_or_equals_for_ids exception

rubyonrails-talk
1

Hi,

Oracle Database using ActiveRecord 2.3.3 is throwing an exception when performing a find call. OvaSchedule.find(:all, :include => [:ova_program])

The root cause seems to be the following: in file: association_preload.rb method "in_or_equals_for_ids" is generating a sql IN condition. However, in my case there are more than 1000 ids and Oracle does nt like that.

Does anybody have an idea how I might fix that?

Thanks a lot in advance.

2

Worked around that issue by using :offset, :limit in find call...

Just in case anybody else is running into this issue.