mybatis调用oracle存储过程
- 作者: King爱24936524
- 来源: 51数据库
- 2020-09-21
create or replace procedure my_procedure(mypageNo number,mypageSize number,myInfo_Cursor out sys_refcursor)aspageNO number;pageSize number;begin open myInfo_Cursor for select * from product where pid between 1 + (pageNo - 1) * pageSize and 4 + (pageNo - 1) * pageSize; end;
create or replace procedure aaa ( myyear in char, mymonth in char ) is begin select f_22 from attendance where cyear=myyear and cpreiod=mymonth;--存储过程里的select必须有into end; --编译肯定失败啊 --应该这样 create or replace procedure aaa(myyear in varchar2, mymonth in varchar2) is v_tmp varchar2(100); --假设你的attendance.f_22是varchar2类型的 begin select f_22 into v_tmp from attendance where cyear = myyear and cperiod=mymonth;--如果返回是0条或者多于1条也会抱错 end;
create or replace procedure aaa ( myyear in char, mymonth in char ) is begin select f_22 from attendance where cyear=myyear and cpreiod=mymonth;--存储过程里的select必须有into end; --编译肯定失败啊 --应该这样 create or replace procedure aaa(myyear in varchar2, mymonth in varchar2) is v_tmp varchar2(100); --假设你的attendance.f_22是varchar2类型的 begin select f_22 into v_tmp from attendance where cyear = myyear and cperiod=mymonth;--如果返回是0条或者多于1条也会抱错 end;
推荐阅读
