Ora Error 1438
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts ora-01438 how to find column name Ion Excel-DB Don Burleson Blog
sql error: 1438, sqlstate: 22003 ORA-01438: value larger than specified precision allowed for this column tips how to resolve ora-01438 Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note this on the ora-01438 error: ORA-01438: value larger than specified precision allowed for this column number precision in oracle Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column. Action: Enter a value that complies with the numeric column"s precision, or use the MODIFY option with the ALTER TABLE command to expand the precision. Because ORA-01438 often consists of an erred entry in your SQL, itOracle Ora-01438 Which Column
is often the case that syntax needs to be evaluated. For example, in the Oracle Technology Network's forums, a user consistently received ORA-01437 when he is running his procedure. His replier pointed out that the values entered may exceed the column definition, or he was entering the CHAR value in the NUMBER field. From that information, ORA-01438 was successfully resolved. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn
Ora-01438 Identify Column
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users number(5,2) Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping number(10 2) in oracle each other. Join them; it only takes a minute: Sign up “ORA-01438: value larger than specified precision allowed for this column” when inserting 3 up vote 7 down vote favorite I'm running into that error when trying to http://www.dba-oracle.com/t_ora_01438_value_larger_than_specified_precision_allowed_for_this_column.htm insert any number except 0 into a field with format NUMBER (2,2). UPDATE PROG_OWN.PROG_TPORCENTAJE_MERMA SET PCT_MERMA = 3 WHERE IDN_PORCENTAJE_MERMA = 1 [Error Code: 1438, SQL State: 22003] ORA-01438: value larger than specified precision allowed for this column COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS PCT_MERMA 3 NUMBER 2 0 2 It also happens if I try with decimal numbers. Any idea why? sql oracle share|improve this question edited Dec 21 '15 at 13:32 Kiquenet 5,0822487148 asked http://stackoverflow.com/questions/14357816/ora-01438-value-larger-than-specified-precision-allowed-for-this-column-when Jan 16 '13 at 11:52 Luis Sep 1,31521522 If you're trying to restrict the values to a range or specific integers, you might be better off with a check constraint. –Alex Poole Jan 16 '13 at 12:07 add a comment| 2 Answers 2 active oldest votes up vote 17 down vote accepted You can't update with a number greater than zero for datatype number(2,2) is because, the first parameter is the total number of digits in the number and the second one (.i.e 2 here) is the number of digits in decimal part. I guess you can insert or update data <0. i.e. 0.12, 0.95 etc. Please check NUMBER DATATYPE in NUMBER Datatype. share|improve this answer answered Jan 16 '13 at 11:59 TechDo 14.8k42547 add a comment| up vote 9 down vote NUMBER (precision, scale) means precision number of total digits, of which scale digits are right of the decimal point. NUMBER(2,2) in other words means a number with 2 digits, both of which are decimals. You may mean to use NUMBER(4,2) to get 4 digits, of which 2 are decimals. Currently you can just insert values with a zero integer part. More info at the Oracle docs. share|improve this answer answered Jan 16 '13 at 11:59 Joachim Isaksson 116k11135171 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles http://support.esri.com/technical-article/000002330 Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: Oracle ORA-1438 Error Message SDE Error(-51) Underlying DBMS error Extended error code(1438): ORA-01438: value larger than specified precision Cause Oracle 1438 error occurs how to when a column in the source data (shapefile or coverage) has a definition that is not large enough for the data it contains.Many times this is the AREA or PERIMETER column of a data source. Solution or Workaround Try the "-a file=