My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.