Symptom

Running a stored procedure with bind variables results in the following error:

PowerBuilder ODBC trace:

(4a76048): *** ERROR -11025 ***(rc -1) : SQLSTATE = 22003

[Informix][Informix ODBC Driver]Numeric value out of range.

ODBC Trace log:

DIAG [22003] [Informix][Informix ODBC Driver]Numeric value out of range. (-11025)

Environment

PowerBuilder

Informix 9

Informix SDK 2.8.0

Informix ODBC Driver 3.8.1

Cause

The problem was caused by running the Informix 2.8.0 SDK which is not supported in PowerBuilder.

Resolution

Upgrading to the Informix 2.8.1 SDK which contains the Informix 3.8.2 ODBC driver resolves the issue.

1
0