Updating AS400 Files Using DG4DRDA 11.2 or Generic Connectivity (DG4ODBC) Gives Error ORA-28500 And SQLCODE:-7008 (Doc ID 398417.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Oracle Database Gateway for DRDA - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Checked for relevance on 29-May-2008




Symptoms

Generic connectivity has been set up to DB2 on an AS400 using Isiris ODBC driver.

Selects work okay but inserts give the following error -


.

insert into as400.table@database_link ........
*
Error in Line1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_Execute: DB_ODBC_ENGINE (1645): ;
[IBM][iSeries Access ODBC-Driver][DB2 UDB]SQL7008 - ISRMUT in TABLE
Operation invalid. (SQL State: S1000; SQL Code: -7008)
ORA-02063: preceding 2 lines from DATABASE_LINK


This problem can also happen using Database Gateway for DRDA (DG4DRDA) 11.2.

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