My Oracle Support Banner

Does MS SQL Adapter Supports Cursor Or Result Set Return Type For Stored Procedure Without Any Out Variable (Doc ID 2582971.1)

Last updated on AUGUST 29, 2019

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Goal

Does MS SQL Adapter support cursor or result set stored procedure without any out variable.

For eg:

 

USE [OICqueue]
GO
/****** Object:  StoredProcedure [dbo].[sp_xxxxx_test]    Script Date: 8/6/2019 11:29:37 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[sp_xxxxx_test]
-- Add the parameters for the stored procedure here
@customerId varchar(250)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

   -- Insert statements for procedure here
SELECT q.queue_name, q.customer_id from MST_RCONN_QUEUES q where q.customer_id = @customerId
END

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.