- 获取存储过程错误
create or replace function error_info return Varchar IS
error_remark VARCHAR2(4000);
BEGIN
error_remark := '[' || to_char(SYSDATE, 'yyyy-mm-dd hh24:mi') || ']过程异常:' ||
dbms_utility.format_error_backtrace ||
dbms_utility.format_error_stack;
Return error_remark ;
END error_info;