PB 调用存储过程就这么难吗?
存储过程为:
create or replace procedure insurance.updatemedinfo(inp_no in varchar2,icd10_code in varchar2,icd10_text in varchar2,treat_result in varchar2,operation_code1 in varchar2,operation_code2 in varchar2) is
vinpno varchar2(6);
icdcode varchar2(7);
icdtext varchar2(30);
oprcode1 varchar2(7);
oprcode2 varchar2(7);
result char(1);
haveopr char(1);
recnum int;
oprcode varchar2(15);
exec_flag varchar2(5);
error_info varchar2(50);
begin
if( inp_no is null) then
begin
exec_flag :='1';
error_info :='The value of inp_no should not be null';
return;
end;
end if;
。。。。。
end;
==================================
pb 脚本如下:
string ls_icd,ls_patno
string ls_icdcode,ls_icdname,ls_result
string ls_opcode,ls_opname
string ls_opcode1,ls_opname1
gt_disfile.AutoCommit = True
DECLARE msg_proc PROCEDURE FOR INSURANCE.updatemedinfo :ls_patno, :ls_icdname, :ls_icdcode, :ls_result, :ls_opcode, :ls_opcode1
USING gt_disfile ;
EXECUTE msg_proc ;
gt_disfile.AutoCommit = False
MessageBox(gt_disfile.SQLErrText)
报错信息是:
“wrong number or type of arguments in calling insurance.updatemedinfo line 1 column 15”
我在sqlplus 里调用这个存储过程,比如:
call insurance.updatemedinfo '223','2222','2343','1','ttt','tttt'
是成功的。
我不是搞pb的,是和别的公司合作时留下的烂摊子。请高手不吝赐教。