asd4487464 2017-08-21 08:19 采纳率: 0%
浏览 1204

关于用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条回答 默认 最新

  • asd4487464 2017-08-21 09:33
    关注

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

    评论

报告相同问题?

悬赏问题

  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥85 maple软件,solve求反函数,出现rootof怎么办?
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题