Oracle Error Number 1438
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 ora 01438 error in oracle BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL
Sql Error: 1438, Sqlstate: 22003
INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL
Ora-01438 How To Find Column Name
UPDATE WHERE Oracle 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
How To Resolve Ora-01438
Error Message Learn the 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 oracle ora-01438 which column statement. Resolution The option(s) to resolve this 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
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp number precision in oracle Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora-01438 identify column Don Burleson Blog
number(5,2) ORA-01438: value larger than specified precision allowed for this column tips Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note https://www.techonthenet.com/oracle/errors/ora01438.php this on 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: Enter a value that complies with the numeric column"s precision, or use the MODIFY option http://www.dba-oracle.com/t_ora_01438_value_larger_than_specified_precision_allowed_for_this_column.htm 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 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 Oraclehere for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/181344/ora-01438-value-larger-than-specified-precision-allows-for-this-column policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring 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 a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes in oracle 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: