Getting the following error in Activity
"There was a problem getting a list: code: 0 SQLState: 42821
Message: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered." in Activity .
This activity deletes workobject from the Stored Procedure by accepting the WorkObject ID as a parameter.
I will be doing Property Set and execute RDB delete method which in turn calls the Stored Procedure created in postgres SQL.
Please let me know if anyone have come across the error
This seems an issue in the stored procedure in Postgres. Could you please verify if the return type of the procedure and the value in activity are of same type? Also, since this procedure is deleting the data, could you try by removing the OUT parameter from the procedure and also the parameter in the activity to receive the value coming from procedure.
My guess is 'resultset' is expecting some value returned by function even though it is void. It will be great if you or someone can help me to how to call the Stored Procedure in connect sql without return type .
Note: I have tried by removing the resultset in the connect SQL and received the syntax error .