Page Comparison

To call stored procedure from the process designer we would take below steps:

Image Removed

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 Image Added.
2. Expand Others and then Stored Procedure
3. Drag and drop the stored procedure in the canvas.
   Image Added
   
   

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.