title: Value of a host variable in the EXECUTE or OPEN statement is out of range error
body: <p>I am trying to insert HTML content into a column of my table.</p>
  
  <p>This is my code</p>
  
  <pre><code>String Query= "INSERT INTO MyTABLE (id,html) VALUES (?,?)";
  insert = conn.prepareStatement(Query); 
  insert.setInt(1, id);
  insert.setString(2, html);
  </code></pre>
  
  <p>This is my DDL</p>
  
  <pre><code>CREATE TABLE MYTAB
  (
      ID INTEGER NOT NULL,
      PRIMARY KEY (ID),
      HTML VARCHAR (10000) 
  );
  </code></pre>
  
  <p>I am getting the below exception while inserting into html field.</p>
  
  <pre><code>[8/26/13 4:50:01:344 EDT] 00000796 SystemOut     The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.57.110
  </code></pre>
  
  <p>The size of html content is pretty big (it might vary in size so cannot give you the exact size).</p>
  
  <p>The reason I am using <code>varchar</code> is, it is easy to pull in the same html content and display on the UI rather than converting it to xml and defining a XML column in place of varchar column.</p>
  
  <p>Can you please help me out to resolve this issue?</p>