1438 Oracle Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle
Ora 01438 Error In Oracle
PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog sql error: 1438, sqlstate: 22003
ORA-01438: value larger than ora-01438 how to find column name specified precision allowed for this column tips Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note this on the ora-01438 error: ORA-01438:How To Resolve 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 with the ALTER TABLE command to expand the precision.
Number Precision In Oracle
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 Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing ora 01438 number Product Life Cycles Manage Cases Request Case Start Chat
Sql State 22003
Back to results Print Share Is This Content Helpful? Search on GeoNet Submit number(10 2) in oracle 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.dba-oracle.com/t_ora_01438_value_larger_than_specified_precision_allowed_for_this_column.htm 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=
manually or by running wh120). STERLINGPRI Technote (troubleshooting) Problem(Abstract) Oracle Error 1438 is given when trying to create a shipper (either http://www.ibm.com/support/docview.wss?uid=swg21535397 manually or by running wh120). Symptom "01 |1461439 |2 |WH2349 |120 |0 |3 |Oracle |Error |work_ord_pick_ticket.c |1018 |Oracle Err PK72714542.PR72714542 SqlCode 0 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 wh120. Resolving the problem When this kind of error occurs, the following can be done to troubleshoot the in oracle problem:1. Log into the Unix server running the Oracle database and run the following command "oerr ora 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 1438 oracle error 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 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