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 MAY 11, 2022
Applies to:
Oracle Database Gateway for DRDA - Version 11.2.0.4 and laterInformation 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
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 |