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 MAY 11, 2022
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.
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
*
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
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 |
| Cause |
| Solution |