Last updated on JANUARY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
Oracle Database Gateway for DRDA - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 29-May-2008
Generic connectivity has been set up to DB2 on an AS400 using Isiris ODBC driver.
Selects work okay but inserts give the following error -
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms