Hi,
I want to execute a Stored Procedure for that I am using a!executeStoredProcedureForQuery() function but I am getting following Error. Also, I tried with ExecuteStoreProcedure smart service but there also giving same error. I am using postgres DB. In Database I am able to execute it, but from Appian end it is giving error.
Thanks,
Kiran
Discussion posts and replies are publicly visible
I am not sure how much sense it will make but the data source needs to be constant since you are not using jdbc/Appian. Also, the documentation has some special configurations for Postgres Db which you can find here - https://docs.appian.com/suite/help/22.2/fnc_system_a_executestoredprocedureforquery.html#postgresql
I tried with using Constant also, this is not the issue
Can you elaborate more on the postgres Configurations.
I added a link there. You can refer that!