Using UPDATE SQL With Generic Connectivity Fails with ORA-28500 Column Not Updatable

(Doc ID 276284.1)

Last updated on AUGUST 27, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1 - Release: 9.2 to 10.2
Microsoft Windows (32-bit)
Reviewed 27-AUG-2010 - MXALLEN.US

Symptoms

SQL> UPDATE <table_name>@<db_link_to_as400> SET <column_name> = <value>;
fails with:
UPDATE <table_name>@<db_link_to_as400> SET <column_name> = <value>
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][A055] The column <column_name> is not updatable.
ORA-02063: preceding 2 lines from <db_link_to_as400>

All other SQL -statements like: SELECT, INSERT, DELETE are working without problems.

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