title: How to insert Large clob data(>4K characters) in oracle 10g using jdbc
body: <p>Could you guys please tell me how to insert clob data using jdbc. Iam using oracle10g database.</p>
  
  <p>I was able to insert clob data having length &lt; 4000 using the below 2 methods</p>
  
  <p>1.</p>
  
  <pre><code>tempClob.length()&lt;4000){
     pstmnt.setClob(colNumber, tempClob );
  }
  </code></pre>
  
  <p>2.</p>
  
  <pre><code>tempClob.length()&lt;4000){
     Reader reader =tempClob.getCharacterStream();
     pstmnt.setClob(colNumber, tempClob );
     pstmnt.setCharacterStream(colNumber, reader, new Long(tempClob.length()).intValue());
  }
  </code></pre>
  
  <p>When the length of the clob data is large for example abt 29k, both these methods fail.</p>