ORA-28500 MySQL NativeErr = 1598 Error Binary Logging Not Possible Using DG4ODBC (Doc ID 1354038.1)

Last updated on SEPTEMBER 15, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Goal

When using the Database Gateway for ODBC  (DG4ODBC) with a database link to connect to a MySQL database where the isolation mode is set to REPEATABLE_READ then Oracle doesn't appear support that isolation mode.
ORA-28500 errors are returned when running specific statements.
This note describes how to handle the errors.


Solution

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