ORA-01425: escape character must be character string of length 1 when using "Oracle.ManagedDataAcces

Dec 21, 2017 1:54PM

New database

=============================================================

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

CORE 12.2.0.1.0 Production

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

Old database

=============================================================

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Recently our DBA upgraded Oracle database (see versions above). The C# MVC web application uses the following versions of Oracle driver

Oracle.ManagedDataAccess -Version 12.1.24160719

Oracle.ManagedDataAccess.EntityFramework -Version 12.1.2400

When running C# Linq query (using LinqKit -Version 1.1.9)

var term = "QUE"

Windows Oracle Data Access Components (MOSC)