java 获取存储过程结果,java获取存储过程结果解决方法

SQL code包头：

create or replace package pkg_test is

type t_test IS RECORD(

list_id number,

dept varchar2,

name varchar2,

age number,

level number,

address varchar2);

type tab_test is table of t_test index by binary_integer;

procedure p_get_data_test(dept in varchar2,

age in number,

enter_date in varchar2,

end_date in varchar2,

report_data out tab_test);

end pkg_test;

包体:

create or replace package pkg_test is

procedure p_get_data_test(dept in varchar2,

age in number,

enter_date in varchar2,

end_date in varchar2,

report_data out tab_test) as

cursor c_get_data is

select list_id, '', name, age, -1, address

from t_user

where 1= 1;

m_t_test t_test;

m_tab_test tab_test;

m_dept varchar2(20);

m_level number := -1;

m_list_id number := 0;

m_count number := 0;

begin

open c_get_data;

fetch c_get_data into m_t_test;

exit when c_get_data%notfound;

loop

m_list_id := m_t_test.list_id;

m_dept := p_get_dept(m_list_id);

m_level := p_get_level(m_list_id);

m_t_test.dept := m_dept;

m_t_test.level := m_level;

m_tab_test(m_count) := m_t_test;

m_count := m_count + 1;

end loop;

close c_get_data;

end p_get_data_test;

end pkg_test;