oracle mybatis 提示:java.sql.SQLSyntaxErrorException: ORA-00913: 值过多
小虾米
阅读：1283
2021-03-31 13:26:39
评论：0
错误信息：
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00913: 值过多
### The error may involve com.zzg.mapper.in.DSingleProjectMapper.batchInsert-Inline
### The error occurred while setting parameters
### SQL: insert into D_SINGLE_PROJECT (KID, ENG_SID, LENGTH, WIDTH, HEIGHT, SPAN, CONS_TYPE_CODE, CREATED_BY, CREATED_DT, UPDATED_BY, UPDATED_DT, OLD_FLAG, DIVISION_SITUATION) select s_d_single_project.nextval, cd.* from ( ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) UNION ALL ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) UNION ALL ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) UNION ALL ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) UNION ALL ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) UNION ALL ( select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual ) ) cd
### Cause: java.sql.SQLSyntaxErrorException: ORA-00913: 值过多
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00913: 值过多造成原因：插入字段与字段名称无法一一对应。
声明
1.本站遵循行业规范，任何转载的稿件都会明确标注作者和来源；2.本站的原创文章，请转载时务必注明文章作者和来源，不尊重原创的行为我们将追究责任；3.作者投稿可能会经我们编辑修改或补充。
