All Apps and Add-ons

How to access OUTPUT variables from Stored Procedure called by dbxquery?

plaxosi
Explorer

I am calling a Stored Procedure in MS SQL using dbxquery:

 

 


The Stored Procedure is configured with:

 

EXECUTE @RC = [dbo].[getSomeData]
   @time
  ,@interval
  ,@retVal OUTPUT
  ,@retErrorMessage OUTPUT
GO

 

Am I able to access the values returned in the OUTPUT variables, i.e. retVal and retErrorMessage, from the stored procedure?

All help and insight is appreciated.

Thanks

Labels (1)
Tags (2)
0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...