Oracle package 定义和java调用_oracle package与java-优快云博客

本文链接：https://blog.youkuaiyun.com/a412588063/article/details/21517863

本文介绍了如何在Oracle中定义package和package body，并详细展示了如何使用Java进行调用。通过建立CallableStatement，设置输入输出参数，执行查询并获取ResultSet，实现了对Oracle包中存储过程的调用和结果的处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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<String> columns = new ArrayList<String>();
            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();
            }