Stored procedures
Last updated
Was this helpful?
Last updated
Was this helpful?
With the stored procedure provider it is possible to call a stored procedure in one of your databases when a record is created, updated, deleted or when a data import has been done.
On the bottom you can find the actual statement that will be executed on the database when the workflow is triggered. The Try now button on the top right will execute this statement directly to test the execution.
When the try button does not return an error the stored procedure is executed successfully.
For SQL Server it is important that the name of the fields matches the name of the input parameters of your stored procedure
For other databases like MYSQL or PostgreSQL the sequence of the fields matter. As the example in the management console displays, the fields will be sent in the order of the list.
In this example we create a stored procedure that will consume 4 fields (user, status, accountmanager and sales_amount. It will write this data to a table `stored_procedure_data`.