Errors Sqlcode=-440 And Sqlstate=42884 With DRDA_CAPABILITY=TO_NUMBER/ON Using DG4DRDA
(Doc ID 431467.1)
Last updated on FEBRUARY 15, 2023
Applies to:
Oracle Database Gateway for DRDA - Version 10.2.0.1.0 to 11.1.0.7Information in this document applies to any platform.
****These error messages and fixes are not relevant for DG4DRDA 11.2 version *********
Symptoms
After an upgrade of the RDBMS version to 10.2 with fix for <bug 4864563> and setting the Database or Transparent Gateway for DRDA (TG4DRDA 10.2 or DG4DRDA 11.1) init<sid>.ora parameter -
DRDA_CAPABILITY=TO_NUMBER/ON
You may receive the following error message running SQL statements -
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
TG4DRDA v10.2.0.2.0 grc=0, drc=-777 (839C,0000), errp=DSNXORFN
sqlcode=-440, sqlstate=42884, errd=FFFFFF9C,0,0,FFFFFFFF,0,0
errmc=FUNCTION,TO_NUMBER
ORA-2063: preceding 4 lines from DB2
TG4DRDA v10.2.0.2.0 grc=0, drc=-777 (839C,0000), errp=DSNXORFN
sqlcode=-440, sqlstate=42884, errd=FFFFFF9C,0,0,FFFFFFFF,0,0
errmc=FUNCTION,TO_NUMBER
ORA-2063: preceding 4 lines from DB2
Changes
These error messages and fixes are not relevant for the DG4DRDA 11.2 version.
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 |
| Changes |
| Cause |
| Solution |
| References |