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
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
SELECT @@IDENTITY, AColumn OR (simple) SELECT @@IDENTITY, NULL