My Oracle Support Banner

DG4ODBC 11.2 Gives Errors ORA-28500 or ORA-01858 Connecting To Red Brick (Doc ID 1267393.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 11.2 to 11.2
Information in this document applies to any platform.


After configuring the Oracle Database Gateway for ODBC on IBM AIX 6.1 any SELECT from Oracle Server to Red Brick fails with a variety of errors, for example -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:


ERROR:ORA-01858: a non-numeric character was found where a numeric was expected


empty rows are returned for the SELECT


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.