存储过程查询数据

void testCall(Map<String, Object> param);
{
call test_package.test_procedure(
#{id,mode=IN,jdbcType=VARCHAR},
#{emps,mode=OUT,jdbcType=CURSOR,javaType=java.sql.ResultSet,resultMap=SysUserMap}
)
}
– 包
create or replace package test_package is
type resCursor is ref cursor;
procedure test_procedure( com in varchar2,
res out resCursor);
end test_package;

–包体
create or replace package body test_package is
procedure test_procedure(com in varchar2,
res out resCursor) is
begin
open res for select * from SYS_USER where ID = com;
end test_procedure;
end test_package;