Executing Informix Stored Procedure results in “Numeric value out of range” error message – PB Docs 2022

Executing Informix Stored Procedure results in “Numeric value out
of range” error message

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.

1 2	(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)

1	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.

Solution

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

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

PB Docs 2022 Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?