Oracle database error code ORA-01457 – converting column overflows decimal datatype

Oracle Database Error Code ORA-1457 Description :
converting column overflows decimal datatype
Error Cause:
The converted form of the specified expression was too large for the specified type. The problem also occurs in COBOL programs when using COMP-3 in the picture clause, which is acceptable to the Pro*COBOL Precompiler and to COBOL but results in this error.

How to Solve :
Define a larger datatype or correct the data.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»