调用oracle存储过程,如何得到这样的返回值??
ahuu 2005-07-27 10:59:16 存储过程大致如下:
Type retstring is Record
(
a varchar2(6),
b varchar(10)
);
type retstr is table of retstring index by BINARY_INTEGER;
procedure getStr( ret out retstr )is
begin
...
loop
ret(i).a := a1;
ret(i).b := b1;
end loop;
...
end;
然后在java中调用该过程,并且得到ret的值
CallableStatement stmt = null;
stmt = con.prepareCall("{call sp_submitproc(?)}");//调用存储过程
stmt.setRef(1,rs); //这里的参数如何设置,并且rs这个变量如何定义??????
stmt.executeUpdate();
请指教!!