Calling a Stored Procedure from Process Designer

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:

1. In the Process Designer, open the Repository View by clicking the icon .
2. Expand Others and then Stored Procedure
3. 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.

To define the output stream for the stored procedure in the process designer:

1. In the Activity Properties pane, click the STREAMS tab.
2. On the Output tab, in the Name field, enter the name of the output stream.
3. In the Consumer field, select the activity that is going to consume the output stream.
4. 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.