Call Stored Procedure in Workbench ES

[Former Community Member]

Hello,

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.

Thanks, Han

[Former Community Member]

Han,

When you test the statement in the Callable Statement Info Editor, does the stored procedure execute successfully?

Steve

[Former Community Member]

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.

Thanks,

Han Dao