Hello There,
I have installed Splunk DB Connect and all its requirements on ver 9.0
This works pretty well for queries either in Search or in SQL Exploereer.
I want to use a stored procedure to return data using DB Connect.
The procedure works fine in SQL Exploereer, and from the MySQL commang line.
If I try to call the procedure from Splunk Search - I get no results I am using this format:
dbxquery connection=myconn procedure="{call my_nice_proc(@val);}" this should return a text string, or a table of results if the query/procedure retuns 1 or more rows..
Any ideas on what I am missing?
thanks,
eholz1