# CreateSProcCall call not working

**URL:** <https://forum.inductiveautomation.com/t/createsproccall-call-not-working/29648>\
**Category:** Ignition\
**Created:** [November 4, 2019, 5:11pm UTC](https://forum.inductiveautomation.com/t/createsproccall-call-not-working/29648 "2019-11-04T17:11:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![israel.jordan](https://avatars.discourse-cdn.com/v4/letter/i/ce73a5/32.png) [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\
**Post date:** [November 4, 2019, 5:11pm UTC](https://forum.inductiveautomation.com/t/createsproccall-call-not-working/29648/1 "2019-11-04T17:11:04Z")

</div>

Can someone tell me if it is possible to get a result set from this function if the stored procedure uses a temp table? I have been trying and my result set row count is zero.

Thank you

---

<div class="post-metadata">

**Author:** ![JGJohnson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jgjohnson/32/29582_2.png) [@JGJohnson](https://forum.inductiveautomation.com/u/JGJohnson)\
**Post date:** [November 6, 2019, 4:18pm UTC](https://forum.inductiveautomation.com/t/createsproccall-call-not-working/29648/2 "2019-11-06T16:18:10Z")

</div>

Before you edited your post this last time I saw that you had this line in your script:

```auto
spCall.registerInParam(“procedure”, system.db.VARCHAR, 40)

```

It should be

```auto
spCall.registerInParam(“procedure”, system.db.VARCHAR, "40")

```

You might try fixing that line and the other line that was similar but with a 20 instead of 40 and see if that doesn’t fix the problem.

When pasting code or other plain text in the forum, use a line with just three backquotes above the code, and again below the code, so it formats nicely.