Update or Delete of MySQL or Informix Using DG4ODBC Gives ORA-28500 and Syntax Error Message (Doc ID 1372126.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

A delete or update of MySQL or Informix using 11.2 Database Gateway for ODBC (DG4ODBC) can give the following errors -

delete from "table_events_rec"@dg4odbc where "event_id">730
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'A1 WHERE A1.event_id>730' at line 1 {42000,NativeErr =
1064}
ORA-02063: preceding 2 lines from DG4ODBC


or

update "owner"."table_name"@dg4odbc set "sta_chg"=20
where "nuc_chg"=199
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Informix][Informix ODBC Driver][Informix]A syntax error has occurred.
{42000,NativeErr = -201}
ORA-02063: preceding 2 lines from DG4ODBC

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