Question

mybatis怎么调用oracle存储过程

Answer 1

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;