All Apps and Add-ons

How to call a Stored Procedure on my SQL server using Splunk DB Connect 2?

shan_santosh
Explorer

I have Stored Procedure on my SQL server and want to call the SP after regular intervals and index the SP return result set. How can this be possible using the Splunk DB Connect 2 app?

0 Karma

joao_amorim
Communicator

I run two SP's in SQL with DB Con v1 and they work but I can't run them in DB Con v2. Try DB Con v1, they will probably work.
Just do EXEC stored_proc_name

0 Karma

herinj
New Member

Hi!

We have written the procedure on oracle db named TEST1 its working fine while we run in on Oracle SQL developer.

But when trying to run it on Splunk DB connect as EXEC TEST1; or EXEC TEST1 it gives below error.

Invalid Query
External search command 'dbxquery' returned error code 1. Script output = "RuntimeError: Failed to run query: "EXEC TEST1;", params: "None", caused by: Exception(' java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement\n.',). "

Could you please help.

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...