April 2, 2014 at 6:22 am
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?
April 2, 2014 at 1:49 pm
Does have any thought?
April 3, 2014 at 1:09 am
up
Didn't anybody had migration from sql 2008 r2 to 2012 with oracle linked server?
April 3, 2014 at 8:17 am
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