My Oracle Support Banner

Errors Sqlcode=-440 And Sqlstate=42884 With DRDA_CAPABILITY=TO_NUMBER/ON Using DG4DRDA (Doc ID 431467.1)

Last updated on AUGUST 04, 2011

Applies to:

Oracle Database Gateway for DRDA - Version: 10.2.0.1.0 to 11.1.0.7 - Release: to 11.1
Information in this document applies to any platform.
***Checked for relevance on 07-Jul-2011***

****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 <> 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

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

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