Skip to main content
K
kirang100133
August 17, 2022
Question

Execute Stored Procedure

  • August 17, 2022
  • 4 replies
  • 0 views

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

    4 replies

    harshitb6843
    harshitb6843
    August 17, 2022

    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

    K
    kirang100133Author
    August 17, 2022

    I tried with using Constant also, this is not the issue 

    Terms & ConditionsAccessibility statement