dbms_errlog.create_error_log
(
dml_table_name -- in varchar2
err_log_table_name -- in varchar2 未指定时:err$_tablename
err_log_table_owner -- in varchar2
err_log_table_space -- in varchar2
skip_unsupported -- in boolean :=false
)
--不支持 long、clob、blob、bfile
log errors [into err_log_table_name[(tag)] reject limit unlimited | n(0) n为整数常量值]
err_log_numbers=n+1
在forall中
sql%rowcount、sql%bulk_exceptions.count 、log errors reject limit 均是累加
errlog行级
save exceptions 语句级
(
dml_table_name -- in varchar2
err_log_table_name -- in varchar2 未指定时:err$_tablename
err_log_table_owner -- in varchar2
err_log_table_space -- in varchar2
skip_unsupported -- in boolean :=false
)
--不支持 long、clob、blob、bfile
log errors [into err_log_table_name[(tag)] reject limit unlimited | n(0) n为整数常量值]
err_log_numbers=n+1
在forall中
sql%rowcount、sql%bulk_exceptions.count 、log errors reject limit 均是累加
errlog行级
save exceptions 语句级