Ora-01858 Selecting via The Oracle Provider for OLEDB

(Doc ID 761480.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 14-Jun-2017***


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


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms