# Stored Procs with Multiple Resultsets

**URL:** <https://forum.inductiveautomation.com/t/stored-procs-with-multiple-resultsets/6696>\
**Category:** General Discussion\
**Created:** [June 12, 2013, 2:08pm UTC](https://forum.inductiveautomation.com/t/stored-procs-with-multiple-resultsets/6696 "2013-06-12T14:08:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![drettberg](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@drettberg](https://forum.inductiveautomation.com/u/drettberg)\
**Post date:** [June 12, 2013, 2:08pm UTC](https://forum.inductiveautomation.com/t/stored-procs-with-multiple-resultsets/6696/1 "2013-06-12T14:08:36Z")

</div>

Can Ignition access multiple resultsets returned from a stored procedure?

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [July 13, 2013, 12:01am UTC](https://forum.inductiveautomation.com/t/stored-procs-with-multiple-resultsets/6696/2 "2013-07-13T00:01:23Z")

</div>

I believe you spoke with Anna in support today, but for anyone else that comes across this:

In a stored procedure you can access multiple output parameters (of a specific type, the list is [here](http://localhost:8088/main/system/help/system_db_createsproccall.htm)) or a single returned value, but not both.