如题,如果在java中调用oracle的存储过程,但输出参数是record类型的,如何获得结果啊create or replace package recordpack
is
type student_type is record(
id number,
name varchar2(20)
);
end;
create or replace procedure recordPro(v_record out recordpack.student_type)
is
begin
select id,name into v_record from student where id=11;
end;
请问我如何在java中调用recordPro这个存储过程病获得结果?
is
type student_type is record(
id number,
name varchar2(20)
);
end;
create or replace procedure recordPro(v_record out recordpack.student_type)
is
begin
select id,name into v_record from student where id=11;
end;
请问我如何在java中调用recordPro这个存储过程病获得结果?
不过为什么不返回一个cursor
去java问吧create or replace procedure recordPro(v_record out recordpack.student_type)
is
begin
select id,name bulk collect into v_record from student where id=11;
end;这样写不行 返回数组也不是你这种写法