ORA-02055 While Processing DATE Field In MYSQL Table Accessed Via DG4ODBC 12c

(Doc ID 2398108.1)

Last updated on MAY 16, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting ORA-02055 while processing DATE field in MYSQL table accessed via Database Gateway for ODBC (DG4ODBC) 12c.

The procedure aborts with "ORA-02055: distributed update operation failed; rollback required" error from Oracle database 12c, whereas the same code snippet works from 11g with no issues.

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