存储中怎么样跳过异常继续运行，谢谢

显示全部楼层 · 2010-10-8 09:28:52

假设像下面这样，有四段语句，其中1，3段出错了，怎么写可以让2，4段会正常运行完成，谢谢
CREATE OR REPLACE PROCEDURE ch_proc_cs
as
begin
insert into sydsb select * from sycjdsb;
commit;
insert into temp select 1 from dual;
commit;
insert into tempsysb select 1 from dual;
commit;
insert into temp select 2 from dual;
commit;

end ch_proc_cs;

千问 · 2010-10-8 09:28:52

CREATE OR REPLACE PROCEDURE ch_proc_cs
as
begin
BEGIN
insert into sydsb select * from sycjdsb;
commit;
EXCEPTION
WHEN XXXXXX THEN --------- 把你希望跳过的异常放在这里

记录错误日志;
END;
insert into temp select 1 from dual;
commit;
BEGIN
insert into tempsysb select 1 from dual;
commit;
EXCEPTION
WHEN XXXXXX THEN --------- 把你希望跳过的异常放在这里

记录错误日志;
END;
insert into temp select 2 from dual;
commit;

end ch_proc_cs;

千问 · 2010-10-8 09:28:52

newkid 发表于 2016-11-2 22:23
CREATE OR REPLACE PROCEDURE ch_proc_cs
as
begin
非常感谢，可以了！