Having trouble calling stored procedure

Ignition
1

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

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?

2

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.

2 Likes
3

Thanks, works