Database Stored Procedure Call

Database Stored Procedure Call

The advanced utilities workflow component,  Database Stored Procedure Call executes a stored procedure/function that has been created in the database.

A prerequisite for this workflow component is, that the general setting for Database execution: Allow database stored procedure call is enabled. InterformNG2 will refuse to add and execute this component if this feature is not enabled.

It can be configured like below:

The parameters are:
  1. Database
    The name of the database defined in the tenant settings. You can select it via the drop down list.
  2. Stored procedure name
    Specify the name of the procedure that is to be called.
  3. Parameter number/parameter value
    If the stored procedure has input parameters, add a parameter row for each input parameter. The parameter number must match the order of the parameter in the procedure definition, with the first parameter being number 1.

Known limitations of stored procedure calls

  • Only integer, double precision floating point and varchar input parameters are fully supported. Other data types may not work.

  • On PostgreSQL it is only possible to call functions, not procedures.

  • This functionality has only been tested with MySQL, PostgreSQL and MS SQL Server