How to call stored procedure from SPLUNK DB CONNECT ?

[abhishekkalokhe]

i have following stored procedure in SYBASE database

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

and i tried calling it as :-

CALL sp_cpu_busy_thread_test
EXEC spcpu_busy_thread_test
EXEC sp_cpu_busy_thread_test();

after that i am getting following errors:-

SybSQLException: Execute cursur 'jconnect_implicit_1' 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.

[koshyk]

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