i am in the process of moving some tables from a SQL 2005 environment to SQL2008r2 and have encountered an issue with an Oracle linked server. When I execute the following openquery
FROM OPENQUERY(REVENUEDM, 'select * from ORACLEDB.client_test')
OLE DB provider "OraOLEDB.Oracle" for linked server "REVENUEDM" returned message "ORA-01858: a non-numeric character was found where a numeric was expected".
My question is I suspect this is an issue with the ORACLE driver for SQL Server but is there any way around this and how is it possible to find the offending data as no matter what I tried in the query I was getting the same error.
Any assistance would help.