MyBatis调用oracle的自定义函数

fn_no_make这个就是我的方法名字。直接调用传入参数。经过实验证明该方式可行

insert into application
        (application_id,
        serial_number,
        application_type,
        applicant,
        agent,
        process_id,
        reason,
        createtime,
        creater,
        updatetime,
        updater)
        values
        (#{applicationId},fn_no_make('app'),
        #{applicationType},#{applicant},#{agent},#{processId},#{reason},#{createTime},#{creater},#{updateTime},#{updater})

再继续加深一点
传入参数和使用函数

<insert id="saveResApplication" parameterType="com.asiainfo.modules.pas.bean.ApplicationBean">
        insert into application
        (application_id,
        serial_number,
        application_type,
        applicant,
        agent,
        process_id,
        reason,
        createtime,
        creater,
        updatetime,
        updater)
        values
        (#{applicationId},fn_no_make(substr(#{applicationId},1,3),'application','serial_number'),
        #{applicationType},#{applicant},#{agent},#{processId},#{reason},#{createTime},#{creater},#{updateTime},#{updater})
    </insert>