CREATE PROCEDURE handler() LANGUAGE SQLBEGINdeclare r_code int;declare err_msg char(64);declare SQLCODE integer default 0;DECLARE continue HANDLER FOR SQLEXCEPTIONbeginset r_code=SQLCODE...
显示全部
CREATE PROCEDURE handler()
LANGUAGE SQL
BEGIN
declare r_code int;
declare err_msg char(64);
declare SQLCODE integer default 0;
DECLARE continue HANDLER FOR SQLEXCEPTION
begin
set r_code=SQLCODE;
set err_msg='处理'||char(r_code)||'出错';
insert into t2 values(r_code,err_msg);
end;
insert into t1 values(3);
insert into t1 values(30);
END
:)
收起