# Having trouble calling stored procedure

**URL:** <https://forum.inductiveautomation.com/t/having-trouble-calling-stored-procedure/81825>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 13, 2023, 8:01pm UTC](https://forum.inductiveautomation.com/t/having-trouble-calling-stored-procedure/81825 "2023-11-13T20:01:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tim\_Buckner](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@Tim\_Buckner](https://forum.inductiveautomation.com/u/Tim_Buckner)\
**Post date:** [November 13, 2023, 8:01pm UTC](https://forum.inductiveautomation.com/t/having-trouble-calling-stored-procedure/81825/1 "2023-11-13T20:01:56Z")

</div>

I am attempting to call a store produced from a named query. I am attempting to use the link below.

[https://docs.inductiveautomation.com/display/DOC81/SQL+Stored+Procedures](https://docs.inductiveautomation.com/display/DOC81/SQL+Stored+Procedures)

It seems fairly straight forward. My first attempt is calling a procedure with no input variables. So the call is "Call GetProductDesc()". I see the tables in the side window, so I know I have the correct db selected.

But I get an error message of "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'." While the error message has a period, I do not in the call. I have recently found another situation the error message was incorrect. Any ideas?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [November 13, 2023, 9:22pm UTC](https://forum.inductiveautomation.com/t/having-trouble-calling-stored-procedure/81825/2 "2023-11-13T21:22:55Z")

</div>

Based on the error, you are connecting or attempting to run the stored procedure on a Microsoft SQL server. In that case you have the wrong syntax, it should be `EXECUTE GetProductDesc;`. The syntax you are currently using is for MySQL.

---

<div class="post-metadata">

**Author:** ![Tim\_Buckner](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@Tim\_Buckner](https://forum.inductiveautomation.com/u/Tim_Buckner)\
**Post date:** [November 13, 2023, 9:24pm UTC](https://forum.inductiveautomation.com/t/having-trouble-calling-stored-procedure/81825/3 "2023-11-13T21:24:05Z")

</div>

Thanks, works