Ora 1438 Error
Contents |
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS ora-01438 how to find column name DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT how to resolve ora-01438 NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle sql error: 1438, sqlstate: 22003 Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-01438 Error Message Learn the
Number Precision In Oracle
cause and how to resolve the ORA-01438 error message in Oracle. Description When you encounter an ORA-01438 error, the following error message will appear: ORA-01438: value larger than specified precision allows for this column Cause You tried to assign a numeric value to a column, but the value was larger than the column will allow. This occurred during either an INSERT or an UPDATE statement. Resolution The option(s) to resolve this oracle ora-01438 which column Oracle error are: Option #1 Assign a smaller precision value to the column. Option #2 Modify the definition of the table to allow for a higher precision number in the column. This can be done with a ALTER TABLE statement. For example, if you had a table called suppliers defined as follows: CREATE TABLE suppliers ( supplier_id number(5) not null, supplier_name varchar2(50) not null ); And you tried to execute the following INSERT statement: INSERT into suppliers (supplier_id, supplier_name) VALUES (123456, 'IBM'); You would receive the following error message: You could correct the error with either of the following solutions: Solution #1 You can correct the INSERT statement to assign a smaller precision value to the supplier_id column as follows: INSERT into suppliers (supplier_id, supplier_name) VALUES (12345, 'IBM'); Solution #2 You can modify the table definition of the suppliers table to allow for a 6 digit precision number. ALTER TABLE suppliers MODIFY supplier_id number(6); Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta oracle error 1438 Discuss the workings and policies of this site About Us Learn
Ora-01438 Identify Column
more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Number(5,2)
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like https://www.techonthenet.com/oracle/errors/ora01438.php 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 allows for this column The full response looks like the following: http://stackoverflow.com/questions/181344/ora-01438-value-larger-than-specified-precision-allows-for-this-column version="1.0" encoding="windows-1251"?>
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 turn JavaScript back on and reload this page. Please enter a title. https://community.oracle.com/thread/592251 You can not post a blank message. Please type your message and try again. More discussions in Data Integrator All PlacesBusiness IntelligenceSystem Management and IntegrationData Integrator This discussion is archived 1 2 Previous Next 16 Replies Latest reply on Mar 22, 2010 5:45 AM by jaleyna-JavaNet ORA-01438: value larger than specified precision allows for this column 593270 Nov 27, 2007 1:29 PM how to Hi, Can anybody help.. Created the target table same structure as the source table.Script for the target table is create table TRG_MTL_SYSTEM as select * from MTL_SYSTEM_ITEMS_B.... and I Successfully reversed the source table and target tables into the models. Created one interface for those target and source tables and mapped columns through auto mapping. When i am executing the interface to load ora 1438 error the data to the target , I am getting these error "ORA-01438: value larger than specified precision allows for this column" while executing the interface. Can anybody suggest me the solution where i did the mistake.. Thanks in Adavance............ 9673Views Tags: none (add) This content has been marked as final. Show 16 replies 1. Re: ORA-01438: value larger than specified precision allows for this column Micropole Nov 27, 2007 1:44 PM (in response to 593270) Which technologies are you using for your Target and your Source ?? Like Show 0 Likes(0) Actions 2. Re: ORA-01438: value larger than specified precision allows for this column 593270 Nov 27, 2007 2:06 PM (in response to Micropole) Thanks for replay... I am using the Oracle technology. Like Show 0 Likes(0) Actions 3. Re: ORA-01438: value larger than specified precision allows for this column Micropole Nov 27, 2007 2:13 PM (in response to 593270) Ok so if your Source and Target are on the same technology and if they both got the same structure you should try to execute a script in a Script Editor like Toad or SQL Plus