title: Getting Java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column.. While inserting the data
body: <p>I'm using Oracle 9.2 with Weblogic 8 server. I'm getting the Data from a table and again I'm updating into the same table with same data. </p>
  
  <p>I am getting the error </p>
  
  <blockquote>
    <p>Java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column. </p>
  </blockquote>
  
  <p>The column is of type <code>varchar2</code> (4000 bytes).</p>
  
  <p>Can some one let me know why this error occurs ? Please do let me know if you like any other information. Below is my SQL Query:</p>
  
  <pre><code>/**
   * @jc:sql statement::
   * UPDATE CORRECTIVE_ACTION SET
   *     CA_ID = {dt.caId}, 
   *     CA_NBR = {dt.caNbr}, 
   *     CAPA_PLAN_ID = {dt.capaPlanId}, 
   *     OBJ_EVIDENCE_COMP = {dt.objEvidenceComp}, 
   *     APPLICABLE_ELSE_WHERE = {dt.applicableElseWhere}, 
   *     JUSTIFICATION = {dt.justification}, 
   *     MOE = {dt.moe}, 
   *     COMPLETION_DATE = {dt.completionDate}, 
   *     EXTENSION_DUE_DATE = {dt.extensionDueDate}, 
   *     STATUS_CD = {dt.statusCd},
   *     SYSTEM_STATUS_CD = {dt.systemStatusCd},  
   *     ROOT_CAUSE_CD = {dt.rootCauseCd}, 
   *     DESCRIPTION = {dt.description}, 
   *     CA_TYPE = {dt.caType}, 
   *     CREATED_BY = {dt.createdBy}, 
   *     CREATED_DATE = {dt.createdDate}, 
   *     MODIFIED_BY = {dt.modifiedBy}, 
   *     MODIFIED_DATE = {dt.modifiedDate},
   *     COMPLETION_DUE_DATE = {dt.completionDueDate}
   * WHERE CA_ID = {dt.caId}
   * ::
   */
  void updateCorrectiveAction(CorrectiveActionDT dt) throws SQLException;
  </code></pre>