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/