G-5010

🆓

Warning

Try to use a error/logging framework for your application.

Rule Details

Severity Level: Critical
Quality Area: Reliability
Fixing times: 5 mins
Local-medium
Database Support: OracleDB (v7.3.4 +)

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

Non-Compliant Example

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;
/

Issues

Line	Column	Message
5	4	Use a logging framework instead of DBMS_OUTPUT.
7	4	Use a logging framework instead of DBMS_OUTPUT.

Compliant Solution - ★★★★★

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;
/

References

same as Trivadis G-5010