1：首先你需要?jiǎng)?chuàng)建一個(gè)包，并定義你返回的游標(biāo)的類型、存儲(chǔ)過(guò)程create or replace package TEST_PKG is
-- Public type declarations type cur_emp is REF CURSOR;
PRocedure test_proc (v_empno in number, emps out cur_emp);
end TEST_PKG;2：然后你再創(chuàng)建包體create or replace package body TEST_PKG isprocedure test_proc (v_empno in number, emps out cur_emp) as begin open emps for select * from emp where empno=7369; end test_proc; end TEST_PKG ;3，通過(guò)java調(diào)用cstmt = conn.prepareCall("{call TEST_PKG .test_proc (?)}"); cstmt.registerOutParameter(1, OracleTypes.CURSOR); cstmt.execute();
