Migration from 2008R2 to 2012, linked servers error

  • Hi!

    We are preparing to migration from 2008R to 2012 and we encountered with query errors to Oracle linked servers.

    This query executing without errors in sql 2008r2

    declare @sSLX_CPR_ID varchar(12),

    @iDURATION int,

    @dFIRSTDAY datetime,

    @fCPRVOL4 float,

    @dACTUALITYDATE datetime

    EXEC ( ' SYSDBA.OPPORTUNITY_LOANMANAGER.FB_GET_CPR_RES(?,?,?,?,?,?); ',

    'O0CEWA002FL1',

    @sSLX_CPR_ID OUTPUT,

    @iDURATION OUTPUT,

    @dFIRSTDAY OUTPUT,

    @fCPRVOL4 OUTPUT,

    @dACTUALITYDATE OUTPUT ) AT SLXORA --with RESULT SETS UNDEFINED

    but in the sql 2012 with error:

    Could not execute statement on remote server

    Configuration of Linked Servers are similar.

    RPCOUT is enable(true)

    If I execute query as :

    EXEC ( 'declare sSLX_CPR_ID varchar(100);

    iDURATION integer;

    dFIRSTDAY date;

    fCPRVOL4 number(10,5);

    dACTUALITYDATE date;

    begin SYSDBA.OPPORTUNITY_LOANMANAGER.FB_GET_CPR_RES(''O0CEWA002FL1'',sSLX_CPR_ID,dFIRSTDAY ,iDURATION ,fCPRVOL4,dACTUALITYDATE);

    end;')

    AT SLXORA

    result without error, but I can't get output parameters.

    How it solved?

  • Does have any thought?

  • up

    Didn't anybody had migration from sql 2008 r2 to 2012 with oracle linked server?

  • we find answer;

    MS SQL Server 2012 was installed on Win 2012R2, Oracle drivers not support this OS .

    Support will be start from version 12.1.0.2. It is version not published yet.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply