title: Hibernate + Oracle IN clause limitation, how to solve it?
body: <p>I know this question is posted many times, but I want to ask about details,</p>
  
  <p>Using Oracle, you can't pass to IN clause more than 1000 parameters, so using hibernate with oracle may have some solutions to this issue like:</p>
  
  <p>1- use OR clause between IN clause for each 1000 Parameters list, but this isn't applicable due to the other limitation by oracle for the whole query parameters not to exceed 2000</p>
  
  <p>2- use a for loop, to run the query in term of 1000 parameters list each time, and then append all the results, this is not very good if you need sorting, or using criteria api with different level modification</p>
  
  <p>3- put the parameters list in a temp physical table, and join it, or even use it in a sub criteria, and this solution I can't try, because I don't know how to create a temp table using hibernate, and then use it,</p>
  
  <p>so if any other thoughts available using CRITERIA api please share it, or even if there's a simple way to handle solution number '3'</p>
  
  <p>Regards, </p>