I have a application which extracts certain details and give me a report. Sometime, due to the large number of objects, the select query generated by the expression fails as the number of expression in 'IN' clause exceeds 1000.

This is Oracle specific issue. I could see for the work-around in the net, but I can change anything in the application.

Is there any limit in the Oracle which can be changed, so that it accepts...