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