I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. Underlying DBMS error[ORA-00936: missing expression]"
I am able to add this Oracle layer to other GUIs such as FME Data Inspector and QGIS. I have added both spatial and non-spatial indexes and have a primary key.
I have been able to connect to and show layers in other Oracle databases in our network, just not from this database. I connected to this database as a user that has select, update, delete, and insert permissions.