G-5010: Try to use a error/logging framework for your application.

Critical

Reliability, Reusability, Testability

Unsupported in db* CODECOP Validators

We cannot identify logging framework and where it should be applied. Requires further definition regarding naming of the error/logging framework and its minimal use in PL/SQL code.

Reason

Having a framework to raise/handle/log your errors allows you to easily avoid duplicate application error numbers and having different error messages for the same type of error.

This kind of framework should include

• Logging (different channels like table, mail, file, etc. if needed)
• Error Raising
• Multilanguage support if needed
• Translate Oracle Database error messages to a user friendly error text
• Error repository

Example (bad)

declare
   co_start constant logger_logs.text%type := 'start';
   co_end   constant logger_logs.text%type := 'end';
begin
   sys.dbms_output.put_line(co_start);
   -- some processing
   sys.dbms_output.put_line(co_end);
end;
/

Example (good)

declare 
   -- see https://github.com/OraOpenSource/Logger
   co_start constant logger_logs.text%type  := 'start';
   co_end   constant logger_logs.text%type  := 'end';
   co_scope constant logger_logs.scope%type := 'demo';
begin
   logger.log(co_start,co_scope);
   -- some processing
   logger.log(co_end,co_scope);
end;
/