Using UPDATE SQL With Generic Connectivity Fails with ORA-28500 Column Not Updatable
(Doc ID 276284.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124 to 10.2.0.1 - Release: 9.2 to 10.2
Microsoft Windows (32-bit)
Reviewed 27-AUG-2010 - MXALLEN.US
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