Calling 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.
   
   
   

You can define the 

• You can define output stream for a stored procedure if Generate Stream option is enabled. See the below screenshot
  
  
  
  
• The default value of Generate Stream option will be according to the Output Mode in the activity.
• If Output Mode is XML Stream then the Generate Stream option will be ON otherwise it will be OFF.
• Stored procedure activity will now generate an output stream.
• Output stream can be defined for stored procedure in Process Designer. See the below screenshot
  
  
  
  
• Now, stream generate by the stored procedure can be consumed by other activities like Data Mapper, Destination etc. See the below screenshot.