[Quote=引用 5 楼 acmain_chm 的回复:]
你的C语言的代码是什么? 一般是过长时间的执行SQL语句会出现这些错误。
[/Quote]
c代码不改,如果把delete from YHQHS where syscdm=vscdm and symdh=vmdh and syxph=vxph and sysyjh=vsyjh;
这几个参数改成具体的值,就不会出错。
[Quote=引用 3 楼 wwwwa 的回复:]
SP代码是什么
[/Quote]
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET bg_all = 1;
begin
SET ret=1;
SET ret2=1;
SET onetime_row=10;
SET read_int=300;
SET begin_pos=1;
insert into A value(sysdate(),vmdh);
if (VXSXPSTR is null ) OR (VXSXPSTR='') then
SET ret2=0;
SET rmsg='no xsxp input';
else
select CSZ into vscdm from XTCS where CSM='SCDM';
delete from YHQHS where syscdm=vscdm and symdh=vmdh and syxph=vxph and sysyjh=vsyjh;
/*insert into YHQHS(syscdm,symdh,syxph,sysyjh) values(vscdm,vmdh,vxph,vsyjh);
delete from `XSXPB` where scdm=vscdm and mdh=vmdh and xph=vxph and syjh=vsyjh ;
delete from `XSXPFKFS` where scdm=vscdm and mdh=vmdh and xph=vxph and syjh=vsyjh ;
delete from `YHQMXB` where scdm=vscdm and mdh=vmdh and xph=vxph and syjh=vsyjh ;*/
end if;
end;