PLS-01907: : number precision too large



PLS-01907: : number precision too large..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23366: integer value string is less than 1

1 Answers  


SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

1 Answers  


ORA-04931: unable to set initial sequence number value

1 Answers  


ORA-39028: cannot restart job from string state

1 Answers  


IMG-00512: multiple incompatible scaling parameters found

1 Answers  






AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


RMAN-03010: fatal error during library cache pre-loading

1 Answers  


ORA-02242: no options specified for ALTER INDEX

1 Answers  


PLS-00329: schema-level type has illegal reference to string

1 Answers  


ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

1 Answers  


RMAN-08532: channel string: restoring block(s) from datafilecopy string

1 Answers  


ORA-32104: cannot retrieve OCI error message

1 Answers  


Categories