How To Call a Stored Function That Returns a REF CURSOR Through SQL Server's Linked Server (Doc ID 580341.1)

Last updated on JUNE 18, 2017

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.1.0 and later   [Release: and later ]
Microsoft Windows (32-bit)

Goal

How to call a stored function that returns a REF CURSOR through SQL Server's Linked Server using Open Query syntax.

Solution

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