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 laterInformation 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 |