62,629
社区成员
发帖
与我相关
我的任务
分享返回结果集和数组
调用存储过程时,如果要用OUTPUT类型返回游标型数据和数组型数据,应该怎么做,如下代码,会出错
CallableStatement funcin = conn.prepareCall ("begin wangjh.selects (?,?); end;");
funcin.setString(1, "1234");
funcin.registerOutParameter (2, Types.OTHER);
funcin.execute ();
存储过程:
create or replace package body wangjh is
procedure selects(user_nm in varchar2,
re_cur out t_cursor
) is
re varchar2(20);
begin
re := 'wangjh';
insert into MT_LOG(LOG_CD,LOG_MESSAGE)values('1',user_nm);
commit;
open re_cur for
select
t.kaisha_cd,t.bmn_cd
from
mt_bmn t;
end selects;
end wangjh;
CallableStatement funcin = conn.prepareCall ("begin wangjh.selects (?,?); end;");
funcin.setString(1, "1234");
funcin.registerOutParameter (2, Types.OTHER);
funcin.execute ();
存储过程:
create or replace package body wangjh is
procedure selects(user_nm in varchar2,
re_cur out t_cursor
) is
re varchar2(20);
begin
re := 'wangjh';
insert into MT_LOG(LOG_CD,LOG_MESSAGE)values('1',user_nm);
commit;
open re_cur for
select
t.kaisha_cd,t.bmn_cd
from
mt_bmn t;
end selects;
end wangjh;
...全文
请发表友善的回复…
发表回复
