create table errorlog
(
id number primary key,
errcode number,
errmsg varchar2(1024),
errdate date
)
创建一张存储错误信息的表
create sequence seq_errorlog_id start with 1 increment by 1
创建一个序列
declare
v_deptno emp.deptno%type:=10;
v_errcode number;
v_errmsg varchar2(1024);
begin
delete from dept where deptno = v_deptno;
commit;
exception
when others then
rollback;
v_errcode:=SQLCODE;
v_errmsg:=SQLERRM;
insert into errorlog values(seq_errorlog_id.nextval,v_errcode,v_errmsg,sysdate);
commit;
end;
执行一段代码,如果出现异常则插入到errorlog这张表中去
(
id number primary key,
errcode number,
errmsg varchar2(1024),
errdate date
)
创建一张存储错误信息的表
create sequence seq_errorlog_id start with 1 increment by 1
创建一个序列
declare
v_deptno emp.deptno%type:=10;
v_errcode number;
v_errmsg varchar2(1024);
begin
delete from dept where deptno = v_deptno;
commit;
exception
when others then
rollback;
v_errcode:=SQLCODE;
v_errmsg:=SQLERRM;
insert into errorlog values(seq_errorlog_id.nextval,v_errcode,v_errmsg,sysdate);
commit;
end;
执行一段代码,如果出现异常则插入到errorlog这张表中去