What does the "Call Stored Procedure" do in workbench ES? Can it be used to return a set of record? If not then is there an alternative way to get a set of values from a SQL Server stored procedure in Workbench? I try to use it to call a stored procedure but it does not seem to work.
Can any one please advise about it.
When you test the statement in the Callable Statement Info Editor, does the stored procedure execute successfully?
It did not give me any result or message but I saw it does execute when I checked the log file. I put the row count variable and see that it return '0' so I assume it returns no row. Can you advise it more.