ORA-01438 error returned with Oracle 12c Cobol programs
Our data center is running Micro Focus Cobol Server Express V5.1 Revision 000 program executables against an Oracle Release 11.2.0.4.0 with no errors and correct data results. We upgraded to Oracle Release 12.1.0.2.0 in which we ran a mass compile of all Micro Focus Cobol programs. Both releases are 64 bit.
Executing the 12c programs some are returning Oracle error "ORA-01438: value larger than specified precision allowed for this column". As a work around for this error we have copied in the Oracle 11g compiled versions. They are running successfully with the Oracle 12c client software and database.
The error is occurring on DML insert, which the value in most, if not all, cases is a zero being stored. The table column definitions consist of number data type, some with only a scale and some with a scale and precision. A trace dump shows the same consistent in-correct data attempting to be stored by the insert in each run with several databases. We did attempt to increase the size of the offending column and the program ran without error, but the data being stored is not correct. Basically we have the same compiler configurations being used in Oracle