Example: Custom stored procedure hook
- Last UpdatedOct 23, 2024
- 1 minute read
This example illustrates how a custom stored procedure can be configured as a hook that can be invoked when executing a standard stored procedure in the MES middleware.
The following example configuration is added to the Middleware Configuration Editor.
|
Configuration Parameter |
Example Entry |
Description |
|---|---|---|
|
Middleware SP Name |
sp_I_UOM |
The actual stored procedure name, supplied out-of-the box, from the MES database. |
|
Pre-Hook Name |
sp_I_Uom_Log |
The custom stored procedure created by the end user in the MES database after installing the MES database. |
|
Pre-Hook Type |
SP |
Indicates that the type of this hook is a stored procedure |
|
Middleware Flow |
STOP ON ERROR |
Indicates to the middleware to stop the execution if there was an error while executing the sp_I_Uom_Log stored procedure. |