"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该如何访问这段存储过程呢
主要不知道游标的type和resultMap该如何写