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 8.1.6.0.0 and later
Microsoft 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

Cause

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