i have an application that is running against an oracle10g database. when i try to perform certain operations in the application, it comes back with the error:
ORA-01795: maximum number of expressions in a list is 1000
then, i look at the sql that is generated and i have:
select <some things> from <table> where <a thing> IN (thing1, thing2, 1000+ more);
can i accomidate more than 1000 expressions in IN clause?if not accomdate in oracle how to write it in java(if there are 5000 records)?