Procedure not return result

Ignition
1

call = system.db.createSProcCall(“usp_GetMixerTagData”)
system.db.execSProcCall(call)
#results = call.getResultSet()
results =call.getReturnValue()
print “Results:”,results
return results
I have create the procedure and call. But I have got none result. Plesae help me how to execurte procedue and get the result.

2

Welcome to the forum. You are using getReturnValue but didn’t specify a return parameter. Something like this depending on how your stored procedure is set up:

call.registerReturnParam(system.db.INTEGER)

You may also want to use getResultSet or getOutParamValue instead. The examples in the documentation here might be helpful:
https://docs.inductiveautomation.com/display/DOC79/system.db.createSProcCall

1 Like