G-5010: Try to use a error/logging framework for your application.
Reliability, Reusability, Testability
Unsupported in PL/SQL Cop 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.
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 error messages to a user friendly error text
- Error repository
1 2 3 4 5 6
1 2 3 4 5 6 7 8 9