title: SQL argument limit in Oracle
body: <p>It appears that there is a limit of 1000 arguments in an Oracle SQL.  I ran into this when generating queries such as....</p>
  
  <pre><code>select * from orders where user_id IN(large list of ids over 1000)
  </code></pre>
  
  <p>My workaround is to create a temporary table, insert the user ids into that first instead of issuing a query via JDBC that has a giant list of parameters in the IN.</p>
  
  <p>Does anybody know of an easier workaround?  Since we are using Hibernate I wonder if it automatically is able to do a similar workaround transparently.</p>