title: Error while Querying : The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use
body: <p>On trying to use a select query statement. The input variable has 8 characters just as expected.</p>
  
  <p>I dont know why this error comes for select query because for a select query it will query and if its available it will return else it will retun blank rows.</p>
  
  <p>Hibernate is used. Even in mapping its correctly mapped as 8 only.</p>
  
  <p>This is what i found in log file:</p>
  
  <pre><code>Cause = com.ibm.db2.jcc.a.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
  </code></pre>
  
  <p>Has anybody come across this error before? Please suggest me some solutions on why this error occurs..</p>