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.registerOutParameter(2, java.sql.Types.VARCHAR); call.executeQuery(); ResultSet rs = (ResultSet) call.getObject(1); String strId = call.getString(2); System.out.println("========: " + strId); ResultSetMetaData md = rs.getMetaData(); int count = md.getColumnCount(); List columns = new ArrayList(); for (int i=1; i<=count; i++) { columns.add(md.getColumnName(i)); System.out.println("列名: " + md.getColumnName(i)); } while(rs.next()) { for (String col:columns) { System.out.print(rs.getObject(col)+" "); } System.out.println(); }