In this blog post, let’s learn about the error message “366 The scale exceeds the maximum precision specified.” in Hydra and the description of the error.
Error Message
366 The scale exceeds the maximum precision specified.
Error Details
A problem exists with the precision or scale of a DECIMAL or a MONEY data type in this statement. Review all uses of these types. The first should be declared as DECIMAL(p) or DECIMAL(p,s) where p, the precision (total number of digits) is between 1 and 32, and s, the scale (number of digits to the right of the decimal point) is no greater than p. The MONEY type follows the same rules.