Trying To Insert Data Into an AS400 Table Using DG4DRDA Fails With ORA-28500 (SQLCODE -7008) (Doc ID 399612.1)

Last updated on JULY 17, 2014

Applies to:

Oracle Database Gateway for DRDA - Version 10.1 to 11.2.0.4
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***


Symptoms


Data inserted into an DB2/400 table through the Database Gateway for DRDA (DG4DRDA) gateway fails with:

ORA-28500: connection from ORACLE to a non-oracle system returned this message:
TG4DRDA V10.1.0.5.0 grc=0, drc=-777 (839C, 0000), errp=QSQOPEN
sqlcode=-7008, sqlstate=55019, errd=F4F3F2F8,0,0,0,0,0
errmc=T1025 ,OTGDB2 ,3



This translates to:
T1025 in OTGDB2 not valid for operation.

--Steps To Reproduce:

SQL> insert into t1025@S10AEF6B.IMB.RU ('Here cyrillic info WIN1251');


-- Business Impact:
Rows in DB2/400 tables cannot be inserted, updated or deleted

 

 

 

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