Neuron ESB User Network

The Service Bus for the Connected Business

We have set up an ODBC adapter to poll a stored proc.

We found that if the stored proc has a temporary table defined the rows returned are always 0.

Any idea why this would be and what we can do to get around it?

Views: 25

Reply to This

Replies to This Discussion

Which vendor is the database? What is the stored procedure code?  Does this code work outside of the ODBC adapter, like in SQL Server Management Studio?

We are using SQL server 2012. The procedure works in SSMS and in other .net applications. 

I tried a simple code like this in the procedure - 

DECLARE @temp TABLE( DataColumn int)
INSERT INTO @temp (DataColumn) VALUES (1);
SELECT DataColumn FROM @temp

Try adding this to the beginning of your stored procedure:

SET NOCOUNT ON;

I created a stored proc with your exact code above and it didn't work.  Adding that line fixed my issue.

Joe

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019
Suman vadde is now a member of Neuron ESB User Network
Dec 16, 2019
Morten Andreasen is now a member of Neuron ESB User Network
Dec 9, 2019
Profile IconCarl Porch, Cordier, Lahbib Marouan and 4 more joined Neuron ESB User Network
Nov 18, 2019
Miroslav Jelev posted a discussion

Using unsupported OAuth provider

Is it possible to create a custom OAuth provider?  Specifically, we are working with Cisco (https://cloudsso.cisco.com/as/token.oauth2).We have a requirement to integrate with a Cisco soap server which uses OAuth2 for authentication. We are using a Service Connector to send a message to the SOAP service, but we need to write custom code in a business process to authenticate with their Cisco OAuth provider. We saw that Neuron supports…See More
Jul 29, 2019
Profile Iconchris comer, Fahd EL YOUBI, Vishal Misal and 2 more joined Neuron ESB User Network
May 16, 2019
Alixx Skevington posted a discussion

Docker Windows 2019 - Neuron 3.5

Hi, We are using 3.5 for our application and I am trying to containerise it for our integration tests.  Building and deploying VM's as this is very time consuming to build and deploy.So I have decided that I to go down docker; everything in our stack has migrated nicely except Neuron.  The first issue was that I needed a later version of the 2016 image or 2019 image from MS which I have. I have managed to install MSMQ on it as well. But when I try to run a silent install everything runs.  But…See More
Apr 15, 2019

Badge

Loading…

© 2021   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service