title: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
body: <p>I have a method in Dao Class that returns <code>List&lt;Object[]&gt;</code> back and I am using named Query</p>
  <pre><code>public List&lt;Object[]&gt; getListByCustomer(Session session, int customerId, List&lt;Integer&gt; strIds) {
    Query namedQuery = session.createSQLQuery(QueryConstants.EXPORT);
    namedQuery.setParameter(&quot;customer&quot;, customerId);
    namedQuery.setParameter(&quot;stringId&quot;, strIds);
    List&lt;Object[]&gt; objects = namedQuery.list();
    return objects;
  }
  </code></pre>
  <p>I want to pass <code>List&lt;Integer&gt; strIds</code> in stringId into the named query as follows :</p>
  <pre><code>public class QueryConstants {
    public static final String EXPORT = 
      &quot;SELECT sv.NAME, sv.TYPE, sv.CLIENT_ADDRESS, sv.NAME_REDUNDANT, sv.DEPARTURE_DATE, s1.CODE,sv.STATE, sv.CODE &quot;
      + &quot;FROM VIEW sv, PROCESS p1, SET s1 &quot; 
      + &quot;WHERE sv.R_ID = p1.R_ID and p1.ISSUER_ID = s1.USER_ID and sv.CUSTOMER_ID = :customer and sv.R_ID IN (:stringId)&quot;;
  }
  </code></pre>
  <p>But I get <code>ORA-00932: inconsistent datatypes: expected NUMBER got BINARY.</code></p>
  <p>Also when I remove <code>sv.R_ID IN (:stringId)</code> from the query it works fine and
  when I pass <code>Integer(strIds)</code> instead of <code>List&lt;Integer&gt; strIds</code> into the query it works fine.</p>
  <p>I'm using Oracle 10g.</p>