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:

Database

The name of the database defined in the tenant settings. You can select it via the drop down list.

Stored procedure name

Specify the name of the procedure that is to be called.

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

• Related Articles

• To database

  This component writes the current workflow payload to a blob column in a database table. You have to specify the name of the database that the output should be saved to. The use of this is primarily intended for workflows that are initiated by the ...

• From database

  A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...

• Enrich spooled file from database

  It is possible to change the contents of a spooled file (as known on the IBM i platform) and to add data from an external database with the advanced special workflow component: Enrich spooled file from database. You can also add data with the ...

• Storing settings and resources in a database

  Storing settings and resources in a database: The InterFormNG2 settings and resources are as default stored in files in the file system, but it is possible to store the settings and resources in a database instead. This is covered in the sections ...

• Database configuration

  The section below describes the database configuration for the From database workflow input, which is very seldomly used. For most you should consider the alternative: From database with custom SQL. To use the database input component, database ...