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 22.214.171.124 to 10.2.0.1 [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
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