My Oracle Support Banner

Using UPDATE SQL With Generic Connectivity Fails with ORA-28500 Column Not Updatable (Doc ID 276284.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Microsoft Windows (32-bit)
Reviewed 27-AUG-2010 - MXALLEN.US


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.