mybatis+oracle 完成插入数据库，并将主键返回的注意事项

mybatis+oracle 完成插入数据库，并将主键返回的注意事项

一条插入语句就踩了不少的坑，
首先我的建表语句是：

create table t_openapi_batch_info(
	BATCH_NO                      VARCHAR2(200),
	UM_CODE                       VARCHAR2(50),
	BATCH_STATUS                  CHAR(1)   DEFAULT '0',
	BATCH_TYPE                    CHAR(1),
	CREATED_DATE                  DATE,
	CREATED_BY                    VARCHAR(100),
	UPDATED_DATE                  DATE
	UPDATED_BY                    VARCHAR(100)
	
)

CREATE SEQUENCE  SEQ_OPENAPI_BATCHNO
minvalue  0
maxvalue   999999999
start wuth  7342937
increate by  1
cache  40;

我写的mapper.xml的sql语句为：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper>
    <insert id="insertBatchInfo" parameterType="java.util.Map" useGeneratedKeys="true" keyColumn ="batchNo">
        <selectKey resultType="int" keyProperty="batchNo" order="BEFORE">
            select seq_openapi_batchno.nextval as batchNo from dual
        </selectKey>
        insert into t_openapi_batch_info
        <include refid=