Database Error Number 1438
Contents |
manually or by running wh120). STERLINGPRI Technote (troubleshooting) Problem(Abstract) Oracle Error 1438 is given when trying to create a shipper (either manually or by running wh120). Symptom "01 |1461439
Database Error Number 1
|2 |WH2349 |120 |0 |3 |Oracle |Error |work_ord_pick_ticket.c |1018 |Oracle Err PK72714542.PR72714542 SqlCode 0 database error number 1 has occurred maximo SQLCD -1438 SqlMessage . |2 |20010205201138 |wmsprod |02001" Error message is being given in the $BASE/log/app_log/$(WHSE)wms_alert_log when trying to create shipper using
Database Error Number 2601
wh120. Resolving the problem When this kind of error occurs, the following can be done to troubleshoot the problem:1. Log into the Unix server running the Oracle database and run the following command "oerr ora database error number 29861 1438"The following error message description displays: 01438, 00000, "value larger than specified precision allows for this column"// *Cause:// *Action:This error states that some column in which an insert is happening has a value larger than the allowed precision. But we do not know which column it is. 2. Determine the table and column locate the package that is creating the error by viewing the error in the error log, PK72714542.PR72714542 SqlCode database error number 1045 0 SQLCD 1438. This message means that the error occurred when a procedure named "PR72714542" was executed from package PK72714542. This means that the error is caused by a SQL statements from this procedure. In this example, the error message is being generated from a insert SQL statement that is inserting values based on some buffer that is being passed by the program. So, if the buffer is acquired correctly, then we will know what fields are causing this error to occur. This package must be modified so the buffer can be written to a file. 3. Add the following statements to the procedure in the package. These statements should be declared before the Begin statements. /*Declare a variable that will hold the buffer that is written into by the program*/ WRT_DEBUG VARCHAR2(500) := ' ';/*Dir name is used for specifying which directory to write. Make sure that Oracle has write permissions to write to this directory*/ DIR_NAME CONSTANT VARCHAR2(50):= '/yantra/prod/wmshome/util/support';/*File name is the file that you want to write to */ FILE_NAM CONSTANT VARCHAR2(20) := 'laks_debug.log'; /*the handle for file operations*/ LOG_HANDLE UTL_FILE.FILE_TYPE; Buffin is the variable that is used for writing the values into the insert statement. 4. Assign the buffin to wrt_debug and write wrt_debug information to file. T
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing
Value Larger Than Specified Precision Allowed For This Column Oracle Error
Product Life Cycles Manage Cases Request Case Start Chat ora-01438 how to find column name Back to results Print Share Is This Content Helpful? Search on GeoNet Submit
Sql Error: 1438, Sqlstate: 22003
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 http://www.ibm.com/support/docview.wss?uid=swg21535397 Cause Oracle 1438 error occurs 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 http://support.esri.com/technical-article/000002330 Try the "-a file=
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://stackoverflow.com/questions/14357816/ora-01438-value-larger-than-specified-precision-allowed-for-this-column-when the workings and 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 4.7 million programmers, just like you, helping each other. database error 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 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 database error number [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,0472486148 asked 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