title: ora-00933:SQL command not properly ended for update sql statement
body: <p>I am getting the sql command not properly ended when hiting this line below.</p>
  
  <pre><code>stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
  String updateQ = "update ANI_999 set First_Name = '"+d.getName()+"', HouseNo = '"+d.getAddr1()+"', Indicator_Sourcefile_iCARE3 = Indicator_Sourcefile_iCARE2, Indicator_Sourcefile_iCARE2 = Indicator_Sourcefile_iCARE1, Indicator_Sourcefile_iCARE1='"+currentFile+"' where CALLER_ID = '"+msisdn+"' ";
  
  int result = stmt.executeUpdate(updateQ);
  conn.commit();
  conn.close();`
  </code></pre>
  
  <p>I keep getting ORA-00933: SQL command not properly ended.</p>
  
  <p>This is what <code>updateQ</code> statement looks like:</p>
  
  <pre><code>update ANI_999 set First_Name = 'ZAHARAH BINTI ABDUL RAHMAN', HouseNo = 'No. JKR6357,', Indicator_Sourcefile_iCARE3 = Indicator_Sourcefile_iCARE2, Indicator_Sourcefile_iCARE2 = Indicator_Sourcefile_iCARE1, Indicator_Sourcefile_iCARE1='ICAREP_ANI_SVCPROF_20120402_002.DAT' where CALLER_ID = '058011726' 
  </code></pre>
  
  <p>here is the full function:- Kindly please refer this symbol "&lt;&lt;"</p>
  
  <pre><code>public void updateRecord(icData d, String msisdn) {
     Connection conn = null;
     Statement stmt = null;
     int recCtr = 0;
  
  try {
     conn = ds.getConnection();
  
         stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
         String updateQ = "update ANI_999 set First_Name = '"+d.getName()+"', HouseNo = '"+d.getAddr1()+"', Indicator_Sourcefile_iCARE3 = Indicator_Sourcefile_iCARE2, Indicator_Sourcefile_iCARE2 = Indicator_Sourcefile_iCARE1, Indicator_Sourcefile_iCARE1='"+currentFile+"' where CALLER_ID = '"+msisdn+"' ";
  
  
     int result = stmt.executeUpdate(updateQ);
     conn.commit();
     conn.close();
  }
  catch(SQLException ex) {
  
      logger.error("iCARE:Error : " + ex.getMessage()); &lt;&lt;this line show me that error&gt;&gt;
  
  }
  finally {
      try {if (stmt != null) stmt.close();} catch (SQLException e) {}
          try {if (conn != null) conn.close();} catch (SQLException e) {}
  }
  }
  </code></pre>