My Oracle Support Banner

Error [Oracle][ODBC DB2 Wire Protocol Driver]Numeric Value Out Of Range. Error In Column 11. {22003} Using DG4DRDA (Doc ID 1900356.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Using the Database Gateway for DRDA  (DG4DRDA) 11.2.0.4.0 to access DB2 on z/OS there are errors compiling a package that uses a link to the gateway.
A select from a table in the package gives the error -

select * from OWNER.TABLE_NAME@DG4DRDA.WORLD where rownum < 5;

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver]Numeric value out of range. Error in column 11. {22003}
ORA-02063: preceding 2 lines from DG4DRDA.WORLD

 
There have been no changes to the Gateway and the packages could previously be successfully compiled.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.