title: ORA-01461: can bind a LONG value only for insert into a LONG column - when inserting into CLOB
body: <p>I am inserting a large string into a <code>CLOB</code> column. The string is (in this instance) 3190 characters long - but can be much larger.</p>
  
  <p>The string consists of xml data - sometimes the data will commit, sometimes i get the error. The error occurs roughly 50% of the time.</p>
  
  <p>Even string which contain over 5000 characters will sometimes commit with no problem.</p>
  
  <p>Unsure where to go next as i am under the impression that <code>CLOB</code> is the best data type for this data.</p>
  
  <p>I have tried <code>LONG</code> <code>LONG RAW</code> </p>
  
  <p>Someone suggested using <code>XMLTYPE</code> however that does not exist in my version of Oracle (11g - 11.2.0.2.0)</p>
  
  <p><strong>My insert statement</strong>:</p>
  
  <pre><code>INSERT INTO MYTABLE(InterfaceId, SourceSystem, Description, Type, Status, StatusNotes, MessageData, CreatedDate, ChangedDate, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  </code></pre>
  
  <p>MessageData is the <code>CLOB</code> column where the error is occuring, i have tried commiting without this data populated and it works.</p>
  
  <p><strong>Error</strong></p>
  
  <pre><code>ORA-01461: can bind a LONG value only for insert into a LONG column
  </code></pre>