Linked server using msdaora. from SQL server to Oracle.

From: Dotan S. <dotan.shdema_at_intel.com>
Date: 6 Sep 2003 10:33:00 -0700
Message-ID: <e5d59d0b.0309060932.486443e8@posting.google.com>

Hi,
Need some help on a weird problem.
I have a linked server from SQL server
to oracle DB (8i) using MSDAORA.
the server is SQL 2K SP3 (I've seen the same issue with SP2 as well). When trying to run a simple query like
select MAX(WW) from table_name (WW defined as NUMBER in oracle.)

I get error
Could not fetch a row from OLE DB provider 'MSDAORA'. [OLE/DB provider returned message: ORA-01426: numeric overflow ]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows returned 0x80040e57].

If I will run the same query without the MAX clause I will get the data from Oracle. any idea?

Thanks Dotan. Received on Sat Sep 06 2003 - 12:33:00 CDT