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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms