java调用代码
Map<String, String> callParams = new HashMap<String, String>(7);
callParams.put("lbbm", codeEntity.getLbbm());
callParams.put("languageGuid", codeEntity.getLanguageGuid());
callParams.put("accountId", account.getGuId());
callParams.put("guId", codeEntity.getGuId());
imStdMaterialCodeDao.p_testprod(callParams);
String validRes = callParams.get("result");
log.info("校验结果:" + validRes);
Mapper中SQL如下
@Select({"call p_testprod( #{lbbm,mode=IN,jdbcType=VARCHAR},#{languageGuid,mode=IN,jdbcType=VARCHAR}" +
",#{accountId,mode=IN,jdbcType=VARCHAR},#{guId,mode=IN,jdbcType=VARCHAR},#{result,mode=OUT,jdbcType=VARCHAR})"})
// void P_WL_WL_DR_CHECKOUT(@Param("lbbm") String lbbm, @Param("languageGuid") String languageGuid
// , @Param("accountId") String accountId, @Param("guId") String guId,@Param("result") String result);
@Options(statementType = StatementType.CALLABLE)
void p_testprod(Map<String, String> params);
存储过程定义如下:
create or replace procedure p_testprod(v_lbdm varchar2,v_lang_id varchar2,v_acc_user varchar2,v_ids varchar2,n_return out varchar2) is