Hi
Is there any way to counter the IN clause limitation of 1000 which exists in oracle.
I have a query something this:
Code:
Query query = session.createQuery("select employees from Employee as employees where employees.emplid IN (:emplidList)");
query.setParameterList("gpin", emplidList);
The employee id list(
emplidList) would run into 20000+. As a result, the query doesn't complete and runs out of memory with an exception. Could you suggest any better approach apart from creating a sub set of 1000 each and executing the query.
Cheers,
Manoj
Login
FAQ
Search
