Skip to main content
April 25, 2022
Question

stored procedure

  • April 25, 2022
  • 2 replies
  • 0 views

How to create SP rule as an inputs are integer type and output also as an integer. 

    2 replies

    April 25, 2022

    /*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",
    {}
    )

    April 25, 2022

    Hi,

    Review Appian documentation here https://docs.appian.com/suite/help/22.1/fnc_system_a_executestoredprocedureforquery.html which provide details related to executeStoredProcedure