存储过程,记录报错表:
-- Create table
create table UTL_ERROR_LOG
(
name CHAR(32) not null,
des VARCHAR2(800),
pk1 CHAR(32) not null,
pk2 CHAR(32),
pk3 CHAR(32),
stepnum NUMBER not null,
sqlnum NUMBER not null,
etime DATE not null
);
-- Add comments to the columns
comment on column UTL_ERROR_LOG.name
is '作业名称';
comment on column UTL_ERROR_LOG.des
is '描述';
comment on column UTL_ERROR_LOG.pk1
is '错误记录键值1';
comment on column UTL_ERROR_LOG.pk2
is '错误记录键值2';
comment on column UTL_ERROR_LOG.pk3
is '错误记录键值3';
comment on column UTL_ERROR_LOG.stepnum
is '错误位置';
comment on column UTL_ERROR_LOG.sqlnum
is 'sql错误码';
comment on column UTL_ERROR_LOG.etime
is '出错时间';