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();             }