Ora-01858 Selecting via The Oracle Provider for OLEDB
(Doc ID 761480.1)
Last updated on OCTOBER 31, 2019
Applies to:
Oracle Provider for OLE DB - Version 8.1.6.0.0 and laterMicrosoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 14-Jun-2017***
Symptoms
Issuing a query via the Oracle Provider for OleDb, the following error may occur:
ORA-01858: a non-numeric character was found where a numeric was expected
Issuing the same query succeeds however, when executed via
- SQL*Plus
- Oracle ODBC Driver
- Microsoft's OLEDB Provider for Oracle
- Microsoft's ODBC Driver for Oracle
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |