Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

TNS-00253: Error in reading network configuration data from file string with error string

1 Answers  


ORA-31010: XML element index string exceeds maximum insertion index string

1 Answers  


NNL-00405: Forwarding information:

1 Answers  


ORA-16571: Data Guard configuration file creation failure

1 Answers  


ORA-25531: MTTR specified is too small: string

1 Answers  


ORA-09762: sNeXT_instanceName: translation error.

1 Answers  


PLS-00406: length of SELECT list in subquery must match number of assignment targets

1 Answers  


NZE-28764: failure to retrieve a configuration parameter

1 Answers  


SQL*Loader-00520: lfimknam failed for file (string)

1 Answers  


KUP-02000: wrong message file version (msg number not found)

1 Answers  


ORA-40213: contradictory values for settings: string, string

1 Answers  


ORA-01922: CASCADE must be specified to drop 'string'

1 Answers  


Categories