This page guide you on the steps required to call and use a stored procedure in a process flow created in the Process Designer.
Follow the steps below to use a stored procedure in a process flow:
- In the Process Designer, open the Repository View by clicking the icon
. - Expand Others and then Stored Procedure
- Drag and drop the stored procedure in the canvas area.
You can also define an output stream for a stored procedure if the Generate Stream option is ON for that stored procedure. See the screenshot below.
| Info |
|---|
| By default, the Generate Steam option will set according to the Output Mode you have selected in the store stored procedure. If you have selected XML Stream as the Output Mode, the Generate Stream option for the stored procedure will be ON, or else it will be OFF. |
To define the output stream for the stored procedure in the process designer:
- In the Activity Properties pane, click the STREAMS tab.
- On the Output tab, in the Name field, enter the name of the output stream.
- In the Consumer field, select the activity that is going to consume the output stream.
- Click
.
Once defined, the output stream generated by the stored procedure can be consumed by other activities in a process flow. See an example below.
| Panel | ||||
|---|---|---|---|---|
| ||||
What is new |