DB2用toad调试存储过程导致数据库服务异常关闭?
如题:
描述:存储过程片段
-- step1 游标循环
begin
declare v_dic_code varchar(50);
declare v_dic_name varchar(50);
declare v_num int;
-- 声明cur1
declare cur1 cursor for
select DIC_CODE,DIC_NAME from S_PB_sysdicinfo where (PDIC_CODE LIKE 'X1001%' OR PDIC_CODE LIKE 'X1002%') ; -- 检查类型
open cur1;
fetch cur1 into v_dic_code, v_dic_name;
while (SQLCODE = 0) do
-- step2 统计数量
select
count(1)
into
v_num
from C_SM_HDINFO sm01
where 1=1
and sm01.IS_ACTIVE = '1'
and sm01.hd_type_self = v_dic_code
and left(CHECK_DATE,4) = v_current_year
;
-- 插入rs
insert into session.tmp_tab1(hd_type_self, hd_type_self_name, num)
values(v_dic_code, v_dic_name, v_num);
fetch cur1 into v_dic_code, v_dic_name;
end while;
close cur1;
end;
在toad调试过程导致服务异常关闭!
疑问1:存储过程如何导致服务异常关闭?有哪些原因和情况?还请各位坛友解惑