# Procedure not return result

**URL:** <https://forum.inductiveautomation.com/t/procedure-not-return-result/22287>\
**Category:** Ignition\
**Tags:** database\
**Created:** [February 1, 2019, 12:38pm UTC](https://forum.inductiveautomation.com/t/procedure-not-return-result/22287 "2019-02-01T12:38:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amol.sawale](https://avatars.discourse-cdn.com/v4/letter/a/57b2e6/32.png) [@amol.sawale](https://forum.inductiveautomation.com/u/amol.sawale)\
**Post date:** [February 1, 2019, 12:38pm UTC](https://forum.inductiveautomation.com/t/procedure-not-return-result/22287/1 "2019-02-01T12:38:46Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [February 1, 2019, 3:24pm UTC](https://forum.inductiveautomation.com/t/procedure-not-return-result/22287/2 "2019-02-01T15:24:38Z")

</div>

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:

```auto
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](https://docs.inductiveautomation.com/display/DOC79/system.db.createSProcCall)