Oracle package 定义和java调用

1.定义package和package body

create or replace package pkg_bicycle_test

is
  PROCEDURE 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