Question

打印出来的sql在plsql中可以执行，程序中报错，什么原因，用的Mybatis+Oracle

insert into BATCH_ORDER ( ID, BATCH_APPLY_ID, DECLARE_ID, USER_ACCOUNT, CUSTOMER_NO, ORDER_ID, ORDER_CHANNEL, SALES_CHANNEL, ADDRESS_LINE, ADDR_CITY, ADDR_COUNTRY, ADDR_DISTRICT, ADDR_STATEORREGION, ADDR_COUNTRY_CODE, ORDER_AMOUNT, PAYMENT_METHOD, BUYER_NAME, BUYER_EMAIL, SPT1, SPT2, SPT3, LOT_NO, ORDER_DATE ) select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, to_timestamp(?, 'yyyy-MM-dd hh24:mi:ss:ff') from dual### Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended] with root causejava.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

Answer 1

foreach结束后加个分号试试。

Answer 2

是xml 文件报错吗？

你这不是遍历订单吗？能把foreach 那块改成 select ....... from 订单表吗？
赶紧你这结构好别扭 insert 语句后边应该是个表或者结果集