G-1050: Avoid using literals in your code.
Literals are often used more than once in your code. Having them defined as a constant reduces typos in your code and improves the maintainability.
All constants should be collated in just one package used as a library. If these constants should be used in SQL too it is good practice to write a deterministic package function for every constant.
In specific situations this rule could lead to an extreme plethora of constants, for example if you use Logger like
logger.append_param(p_params =>l_params, p_name => 'p_param1_todo', p_val => p_param1_todo);, where the value for
p_name always should be the name of the variable that is passed to
p_val. For such cases it would be overkill to add constants for every single variable name you are logging, so if you use Logger or similar, consider making that an exception to the rule, just document exactly which exceptions you will allow and stick to them.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23