ORA-00911 When Opening View on External Data Object that is Filtered on Date Field (Doc ID 748441.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Integration BAM - Version: 10.1.3.1 to 10.1.3.3 - Release: to AS10gR3
Oracle Application Server Integration BAM - Version: 10.1.3.1 to 10.1.3.3 - Release: AS10gR3 to AS10gR3
Information in this document applies to any platform.

Symptoms

When opening a view on an external data object that is filtered on a date field, the following error is seen:

 

ERROR - ActiveDataCache ERROR [42000] [Microsoft][ODBC driver for Oracle][Oracle]  ORA-00911: invalid character





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