All Apps and Add-ons
Highlighted

How to call stored procedure from SPLUNK DB CONNECT ?

i have following stored procedure in SYBASE database

create procedure sp_cpubusythreadtest
as
begin
select @@servername,@@version
end
return(0)

and i tried calling it as :-

CALL spcpubusythread_test
EXEC sp
cpubusythreadtest
EXEC sp
cpubusythreadtest();

after that i am getting following errors:-

SybSQLException: Execute cursur 'jconnectimplicit1' is declared on a procedure which contains a non SELECT or a SELECT with a compute clause. for declaration of this cursor to be legal it should i have a single SELECT statement without a COMPUTE clause.
and
No results found for this query.

0 Karma
Highlighted

Re: How to call stored procedure from SPLUNK DB CONNECT ?

Super Champion

in Dbconnect V3, this is supported I believe
https://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Commands#Required_Arguments
Syntax something like: dbxquery procedure="{call <procedure-name>}"

We couldn't find a simple way in Dbconnect V2, So what we have done is
1. to Create a function on top of the stored procedure
2. And use Select statement to call this function
Very similar to example shown in
https://stackoverflow.com/questions/14506871/how-to-execute-a-stored-procedure-inside-a-select-query

0 Karma