Calling Stored Procedure With Empty Result Set fails When using SQL Server 2k

(Doc ID 1392798.1)

Last updated on JANUARY 10, 2012

Applies to:

Oracle Database Gateway for SQL Server - Version: and later   [Release: 11.2 and later ]
Information in this document applies to any platform.


When executing a procedure that returns an empty result set the gateway fails with error:

ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match
ORA-06512: at "DG4MSQL.SR_EMPTY_REC_SET_ORA1", line 53
ORA-06512: at line 1


Update to and using SQL Server 2000. Using SQL Server 2008 with the same gateway release works fine.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms