topic Re: Execute stored procedure with parameters using datainputs in Splunk Search

Execute stored procedure with parameters using datainputs

suhailquadri — Mon, 18 Sep 2017 12:28:52 GMT

Hi,

I want to execute stored procedure with parameters but it gives me error like "com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set."

DB input:
exec "StaffDeployment"."dbo"."procedurename" @FROMDATE = '9/14/2017', @TODATE = '9/14/2017 23:59:00', @STEV = '1', @Counter = 5, @FieldPosition = '1,2,3,4'

Please help me in this.

Regards
Suhail

Re: Execute stored procedure with parameters using datainputs

DalJeanis — Tue, 19 Sep 2017 16:19:50 GMT

I would expect that to be an issue with the stored procedure itself.

In this case, several sites show this happening to different tools and applications, and the answer is usually "Update the stored procedure to SET NOCOUNT ON". Here are a couple of examples...

https://community.jaspersoft.com/wiki/getting-statement-did-not-return-result-set-error-when-using-stored-procedure-access-mssql-data
http://kb.tableau.com/articles/issue/error-stored-procedure-does-not-return-result-set

There is also a more complete and more complicated answer here, but only go there if you are trying to execute a stored procedure that is SUPPOSED to do something more than return a results set.

https://blogs.msdn.microsoft.com/jdbcteam/2008/08/04/sqlserverexception-the-statement-did-not-return-a-result-set/

Re: Execute stored procedure with parameters using datainputs

zeroCalm — Tue, 19 Sep 2017 16:24:59 GMT

Thank you. I will start on that. I appreciate all of you help on this and other questions up to this point.

Re: Execute stored procedure with parameters using datainputs

caseypike — Fri, 31 May 2019 18:24:59 GMT

Did you figure this out?