How to create SP rule as an inputs are integer type and output also as an integer.
Discussion posts and replies are publicly visible
/*rule input values stored in "ems_person" */index( executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "INSERT_EMS_PERSONS", inputs: { { name: "PersonID_p", value: ri!PersonID_p }, { name: "LastName_p", value: ri!LastName_p }, { name: "FirstName_p", value: ri!FirstName_p }, { name: "Address_p", value: ri!Address_p}, { name: "City_p", value: ri!City_p} }, timeout: 100 ), "result", {})
Hi,
Review Appian documentation here https://docs.appian.com/suite/help/22.1/fnc_system_a_executestoredprocedureforquery.html which provide details related to executeStoredProcedure