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-30083: syntax error was found in interval value expression

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


ORA-06017: NETASY: message receive failure

1 Answers  


ORA-07286: sksagdi: cannot obtain device information.

1 Answers  


ORA-16099: internal error ORA-00600 occurred at standby database

1 Answers  






ORA-01543: tablespace 'string' already exists

1 Answers  


ORA-39093: FLASHBACK automatically enabled to preserve database integrity.

1 Answers  


NNO-00604: disabling all request processing

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  


DRG-12431: configuration section string not found

1 Answers  


QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)

1 Answers  


ORA-24763: transaction operation cannot be completed now

1 Answers  


Categories