locked
Problem while fetching data from Oracle linked server RRS feed

  • Question

  • Hi,

    I created a linked server as follows:

    EXEC sp_addlinkedserver 'OracleLinkedServer', 'Oracle', 'MSDAORA', 'fcstage'

    EXEC sp_addlinkedsrvlogin 'OracleLinkedServer', false, 'SA', 'fc_stage', 'password'

    Now I try firing a simple select statement

    SELECT FINANCIAL_TRX_INFO_ID FROM

    [OracleLinkedServer]..[FC_STAGE].[WFS_FINANCIAL_TRX_INFO]

    WHERE SFS_BUSINESS_SEGMENT IS NOT NULL

    But I get the following error:

    OLE DB provider "MSDAORA" for linked server "OracleLinkedServer" returned message "ORA-01426: numeric overflow

    ".

    Msg 7330, Level 16, State 2, Line 1

    Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "OracleLinkedServer".

    This seems to be a generic error statement. Can anyone tell me where am I going wrong.

    Thanks.

    Monday, March 5, 2007 5:22 PM

Answers

  • Solved using OpenQuery

    SELECT * FROM OPENQUERY([OracleLinkedServer], 'SELECT FINANCIAL_TRX_INFO_ID FROM WFS_FINANCIAL_TRX_INFO') AS Query

    Monday, March 5, 2007 5:36 PM