stored procedure

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

  Discussion posts and replies are publicly visible

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

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

Children
No Data