Problem:

ET-Connector should call a stored procedure on SQL-Server. The stored procedure is executed by using the Database-IN item and the EXEC command:

EXEC <SP-Name> Parameter1, Parameter2, ....

The stored procedure executes, but does not return any values. ET-Connector logs

Update -1 row(s) from 'xyz' for 'abc'

instead of the expected integer result

Solution:

ET-Connector is currently unable to execute stored procedure through parameterized calls via JDBC Callable statements, as the Database IN item is intended to receive result sets.

As a workaround rewrite the stored procedure to return results:

  • Remove the OUTPUT parameters
  • At the last SELECT statement, do not return only one parameter, return multiple values

Example:

Rewrite

SELECT @@IDENTITY

to

SELECT @@IDENTITY, AColumn   OR (simple)   SELECT @@IDENTITY, NULL