Getting Error ORA-01858 when using the Oracle Provider for OLE DB
Hello, I'm not an expert at working with Oracle databases so would appreciate any help you can provide. Currently we're writing an ETL to pull data from Oracle into SQL 2008. The solution is working well in our development environment, connecting to our local Oracle installation. We're hitting the following problem at the customer's staging environment though. I created an OLE DB Source, that uses the Oracle Provider for OLE DB. Then added the following SQL command: SELECT EMP_NO FROM ITS_HR_EPM_EMP_V order by EMP_NO When I click Preview or run the ETL, I get the following error: ORA-01858: a non-numeric character was found where a numeric was expected ORA-01858: a non-numeric character was found where a numeric was expected (OraOLEDB) Using Toad and the same provider, I can run this query against the oracle database with no problem. Is this a codepage issue? Any advice on how to troubleshoot this? I also get the following warning when I click Preview, not sure if it's relevant: Warning at {xxx-xxx- .. } [OLE DB Source[1409]]: Cannot retrieve the column code page info from the OLE DB provider If the component supports the "DefaultCodePage" property, the code page fron that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page fron the component's locale ID will be used. Thank you Sam Amin Software Development Director - BlueCloud www.BlueCloudCorp.com
January 19th, 2011 6:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics