title: Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000?
body: <p>I am using java/hibernate/Oracle.  i have a list with more than 3000 entries. if i pass whole list i get below exception.</p>
  
  <blockquote>
    <p>Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000</p>
  </blockquote>
  
  <p>to solve the issue i am splitting the list into sublists, each sublist will have 1000 entries. for every thousand entries i am firing a query. it is working fine.</p>
  
  <p>Please clarify me, is there any better solution?</p>
  
  <p>Thanks!</p>