New Rule: use FORMAT_ERROR_STACK always with FORMAT_ERROR_BACKTRACE about plsql-and-sql-coding-guidelines HOT 2 CLOSED

BEGIN
  RAISE_APPLICATION_ERROR(-20000, 'This is an error example');
EXCEPTION
  WHEN OTHERS THEN  -- Noncompliant; only FORMAT_ERROR_STACK is used
    DBMS_OUTPUT.PUT(DBMS_UTILITY.FORMAT_ERROR_STACK);           -- "ORA-20000: This is an error example"
    DBMS_OUTPUT.PUT_LINE('');
END;
/

BEGIN
  RAISE_APPLICATION_ERROR(-20000, 'This is an error example');
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT(DBMS_UTILITY.FORMAT_ERROR_STACK);           -- "ORA-20000: This is an error example"
    DBMS_OUTPUT.PUT(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);       -- "ORA-06512: at line 2"
    DBMS_OUTPUT.PUT_LINE('');
END;
/

   EXCEPTION
      WHEN OTHERS THEN
         -- handle backtrace error stack
         l_backtrace := dbms_utility.format_error_backtrace;
         -- log incident and stop logging
         ...logging.process_stop(
            i_process_id           => l_process_id,
            i_incident_description => SQLERRM || chr(10) || l_backtrace
         );
         -- raise exception after logging
         RAISE;