Firstly, I am NO expert in oracle (BOOO!!!).
But I am trying to resolve an error a friend is getting and I am unsure where to go.
There are a few views and tables that he can do a SELECT on but one in particular, he cannot and it makes no sense.
This is the error I get:
OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "ORA-01858: a non-numeric character was found where a numeric was expected"
Any ideas what this means? They are using Oracle 11g if this helps.