Using UPDATE SQL With Generic Connectivity Fails with ORA-28500 Column Not Updatable
Last updated on AUGUST 27, 2010
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52 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.
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