Oracle Error Ora-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 Ion Excel-DB Don Burleson Blog
ora-01438 how to find column name ORA-01438: value larger than specified precision how to resolve ora-01438 allowed for this column tips Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note this onSql Error: 1438, Sqlstate: 22003
the ora-01438 error: ORA-01438: value larger than specified precision allowed for this column Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column. Action:
Number Precision In Oracle
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, it 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 oracle ora-01438 which column 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 for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of Oracle Corporation.
��here for a quick overview of the site Help Center Detailed answers to any questions
Oracle Error 1438
you might have Meta Discuss the workings and policies of ora-01438 identify column this site About Us Learn more about Stack Overflow the company Business Learn more about hiring number(5,2) developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is http://www.dba-oracle.com/t_ora_01438_value_larger_than_specified_precision_allowed_for_this_column.htm a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-01438: value larger than specified precision allows for this column up vote 7 down vote favorite We get sometimes the following error from our partner's database: ORA-01438: value larger than specified precision http://stackoverflow.com/questions/181344/ora-01438-value-larger-than-specified-precision-allows-for-this-column allows for this column The full response looks like the following:
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please https://community.oracle.com/thread/3924413 turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in PeopleSoft General Discussion All PlacesOracle ApplicationsPeopleSoft EnterprisePeopleSoft General Discussion This discussion is archived 1 Reply Latest reply on Apr 28, 2016 oracle error 2:42 PM by Nicole Apostola Error : ORA-01438: value larger than specified precision allowed for this column 2817171 Apr 28, 2016 2:26 PM Hi,I am getting below error while running People soft AE process.ORA-01438: value larger than specified precision allowed for this column.The error doesn't even specify the name of column oracle error ora-1438 and making it difficult to debug the exact column.Any more thought to debug this ?Thanks in advance !! I have the same question Show 0 Likes(0) 107Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: Error : ORA-01438: value larger than specified precision allowed for this column Nicole Apostola Apr 28, 2016 2:42 PM (in response to 2817171) Hi,You've probably got a number field where the number of digits has been exceeded. Example: the field's got a maximum of 4 digits and your result is 101.25.Hope that helps narrow things down...Nicole Like Show 1 Likes(1) Actions Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x