Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCC-02377: Arrays of implicit varchars are not permitted

1 Answers  


ORA-12539: TNS:buffer over- or under-flow

1 Answers  


ORA-14134: indexes cannot use both DESC and REVERSE

1 Answers  


LCD-00201: could not open specified filename [string]

1 Answers  


ORA-13451: GeoRaster metadata scaling function error

1 Answers  






ORA-12723: regular expression too complex

1 Answers  


ORA-13023: interior element interacts with exterior element

1 Answers  


ORA-00365: the specified log is not the correct next log

1 Answers  


NZE-29004: Callback Failure

1 Answers  


PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery

1 Answers  


TNS-12680: Native services disabled but required

1 Answers  


TNS-04003: Syntax Error.

1 Answers  






Categories