Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-34693

(MXXEQ00B) %a value number number
The value %1p is greater than the specified precision (%2p, %3p).

Cause

A numeric value was entered that exceeded the specified precision for this operation. For example, for a specified precision of NUMBER(3,2), the precision or the maximum number of significant decimal digits is 3. The scale or the number of digits from the decimal point to the least significant digit is

  1. In this case, a value of 123.89 will cause the error because

the precision allows a maximum of 3 digits and 2 of them must be to the right of the decimal point. A value of 3.89 will not cause the error.


Action

Enter a value that complies with the specified precision limit.