EXTOL Business Integrator allows users to call SQL Procedures from Business Process Scripts.
In our example below we show the SQL Action the actual SQL Procedure. We will pass in a single variable and return a resultant code.
The SQL statement below will pass input process_name variable and the output value will be return
In the Business Process below we will call the SQL Action. We will be prompted to input: process_name and the output will be passed to the variable: return.
For more information on EBI 2.6
By: Sean Hoppe on