# Stored procedure with output parameters in a named query

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-with-output-parameters-in-a-named-query/57937>\
**Category:** Ignition\
**Created:** [April 1, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-with-output-parameters-in-a-named-query/57937 "2022-04-01T16:08:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_Bridgeman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dan_bridgeman/32/3610_2.png) [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\
**Post date:** [April 1, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-with-output-parameters-in-a-named-query/57937/1 "2022-04-01T16:08:58Z")

</div>

Can you execute a stored procedure which sets an output parameter from a named query? I don’t see anything in the documentation that would explain how to do so.

It’s easy enough to excecute the stored procedure through the system.db functions, but I would like to stick with named queries as much as possible.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 1, 2022, 4:14pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-with-output-parameters-in-a-named-query/57937/2 "2022-04-01T16:14:53Z")

</div>

What would the named query execution engine do with it? It doesn’t have any mechanism to return anything but a dataset for queries or a modify count or primary key for updates.