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 |
TNS-00253: Error in reading network configuration data from file string with error string
ORA-31010: XML element index string exceeds maximum insertion index string
NNL-00405: Forwarding information:
ORA-16571: Data Guard configuration file creation failure
ORA-25531: MTTR specified is too small: string
ORA-09762: sNeXT_instanceName: translation error.
PLS-00406: length of SELECT list in subquery must match number of assignment targets
NZE-28764: failure to retrieve a configuration parameter
SQL*Loader-00520: lfimknam failed for file (string)
KUP-02000: wrong message file version (msg number not found)
ORA-40213: contradictory values for settings: string, string
ORA-01922: CASCADE must be specified to drop 'string'