I am attempting to call a store produced from a named query. I am attempting to use the link below.
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?