PLS-01907: number precision too large

Cause: The number begin copied or assigned had too many digits to the left of the decimal and did not fit into its destination. In other words, there is a number precision mismatch. This error may also occur if, for example, an attempt is made to assign a character string to a number, as demonstrated below. 

a varchar2(4); 

b number(1,1); 

a := '10.1'; 

b := a;

Action: First, check explicit number precision value mismatches. If none are found, then consider implicit conversions of other types to numbers, including conversions performed during binds.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/