cancel
Showing results for 
Search instead for 
Did you mean: 

MS SQL Stored Procedure call error

former_member190695
Participant
0 Kudos

Hi All,

I am calling a remote custom Stored Procedure from a To Database (SAP NW IDM 7.2) task and have the following error message each time an error is reported in the target system. java.lang.Throwable: A result set was generated for update.

The Stored procedure doesn't have any input parameters of type OUTPUT, so I think this is the reason why I am not seeing the real error message in SAP NW IDM.

Any idea's how to deal with this situation?

Many thanks.

Best Regards,

Ridouan Taibi

View Entire Topic
former_member190695
Participant
0 Kudos

Thanks for your prompt response Guys.

I think I have found a solution for my issue.

I have tried to create my own procedure which I call from IdM that makes a call to the remote procedure. This didn't work either even though I had declared an output parameter.

SET NOCOUNT ON was set from the beginning, indeed this is required to prevent the count of rows.

The script sap_core_callStroredProcedure seems to work with a To Database task only.

I am now using a generic task where I basically define my procedure and then use the internal function uSelect to return the output. EXEC @someDeclaredInteger = EXEC someProcedure @withSomeParameters --This is IMPORTANT -- SELECT @someDeclaredInteger

In my case the procedure was returning some application error codes.

Thanks again.

Best Regards,

Ridouan Taibi