Mybatis ORA-00911: 无效字符、批量更新

报错内容：

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

### The error may involve com.zeei.lims.logistics.staff.dao.StaffInfoDao.updateTrainRecordFileId-Inline
### The error occurred while setting parameters
### SQL: update T_JCYW_YH_PXCYRYJLB               SET FILEID = ?               where XH = ?          ;              update T_JCYW_YH_PXCYRYJLB               SET FILEID = ?               where XH = ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

 

sql：

 

 

 

解决办法：增加foreach节点的操作符，具体如下