Question
Postgres Sql error in Activity
Hi Friends,
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
Hi Siva,
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.