1.定义package和package body
create or replace package pkg_bicycle_test
isPROCEDURE pro_fetchuser(ret out sys_refcursor, strId in out varchar2);
end;
create or replace package body pkg_bicycle_test
is
g_var1 varchar2(32);
PROCEDURE pro_fetchuser(ret out sys_refcursor,strId in out varchar2)
as
begin
open ret for
select * from t_user;
g_var1 :=strId;
dbms_output.put_line(g_var1);
strId := 'haha';
end;
end;
2.java调用
Connection conn = session.connection();
CallableStatement call = conn.prepareCall("{call pkg_bicycle_test.pro_fetchuser(?,?)}");
call.registerOutParameter(1, -10);
call.setString(2, "wzw");
call.registerOutParamet