关于用mybatis操作数据库存储过程的问题

"PROCEDURE LATE_FEE_FROZEN_CRT(v_account_no in number,
"
" v_orig_bill_ref_no in varchar2,
"
" v_EFFECTIVE_DATE in date,
"
" v_expire_date in date,
"
" v_chg_who in varchar2,
"
" v_annotation in varchar2,
"
" late_fee_frozen_rec IN OUT ctsh_iam.iam_rec) IS
"
" --func_desc:创建违约金冻结记录
"
" v_msgcode NUMBER;
"
" v_msg VARCHAR2(100);
"
" v_tracking_id NUMBER(30);
"
"BEGIN
"
" if late_fee_frozen_rec%ISOPEN then
"
" close late_fee_frozen_rec;
"
" end if;
"
" select SEQ_LATE_FEE_FROZEN.nextval into v_tracking_id from dual;
"
"
"
" INSERT INTO late_fee_frozen
"
" (ACCOUNT_NO,
"
" ORIG_BILL_REF_NO,
"
" TRACKING_ID,
"
" EFFECTIVE_DATE,
"
" EXPIRE_DATE,
"
" CREATE_DATE,
"
" STATUS,
"
" ANNOTATION,
"
" CHG_WHO,
"
" CHG_DATE)
"
" VALUES
"
" (v_ACCOUNT_NO,
"
" v_ORIG_BILL_REF_NO,
"
" v_TRACKING_ID,
"
" v_EFFECTIVE_DATE,
"
" v_EXPIRE_DATE,
"
" sysdate, --CREATE_DATE,
"
" 1, --STATUS VALID
"
" v_ANNOTATION,
"
" v_CHG_WHO,
"
" sysdate --CHG_DATE
"
" );
"
"
"
" OPEN late_fee_frozen_rec FOR
"
" SELECT * FROM late_fee_frozen where tracking_id = v_tracking_id;
"
"EXCEPTION
"
" WHEN OTHERS THEN
"
" v_msgcode := SQLCODE;
"
" v_msg := SUBSTR(SQLERRM, 1, 100);
"
" raise_application_error(-20001,
"
" 'INSERT LATE_FEE_FROZEN Failed: ' || v_msgcode || ': ' ||
"
" v_msg || '...).');
"
"END;
"

这样一段存储过程,其中有一个参数游标,我现在mybatis的xml该如何访问这段存储过程呢

1个回答

主要不知道游标的type和resultMap该如何写

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐