ORA-00911:invalid character (#911) Error While Using Oracle ODBC Driver 12c

(Doc ID 2149163.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

Oracle ODBC Driver - Version 11.2.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

*** Checked for relevance on 27-Sep-2017 ***

Symptoms

Microsoft Excel 2013 throws ORA-00911 error while executing the below query using Oracle Client 12.1.0.2 when ODBC driver used for connectivity. 

Same query executes successfully in SQL*PLUS and and using Oracle ODBC driver from Oracle Client 11.2.0.3.0

Changes

 Upgraded Oracle Client to 12.1.0.2.0

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