All Apps and Add-ons

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

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

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

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
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!