title: Java Mybatis multiple update statements
body: <p>Java Mybatis Oracle</p>
  
  <p>I have following mybatis statement in xml file</p>
  
  <pre><code>&lt;update id="updateOfferIndex" parameterType="java.util.List"&gt;
     &lt;foreach collection="list" item="offer"  index="index"  separator=";" &gt;
          UPDATE  offer set indx=#{offer.idx} WHERE id=#{offer.eId}
      &lt;/foreach&gt;
  </code></pre>
  
  <p>I am getting following error, can any one help ?</p>
  
  <pre><code>### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  
  ### The error may involve com.dao.linear.upsell.LinearUpsellDao.updateOfferIndex-Inline
  ### The error occurred while setting parameters
  ### SQL: UPDATE  offer set indx=? WHERE id=?   ;       UPDATE  offer set indx=? WHERE id=?
  ### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  </code></pre>