Problem:

Procedure has been migrated from SQLServer 7.0 (where it ran correctly) to Oracle 8.1.7.  The compiler directives are the same as those used for OpenESQL.  However, the problem appears on fields defined as:

     s9(9)v9(6) comp-3

Using this type of field in a SELECT works fine.  Using the same field with an INSERT or UPDATE generates an 'SQL error 1722 Invalid Number'.

Displayed in animate the contents of the field is correct.  The problem does not occur if the field is defined as s9(9) comp.

The version of driver is Oracle 8.1.7.00

Resolution:

This was an issue with the Oracle 8.1.7 ODBC driver.