To call stored procedure from the process designer we would take below steps:
- Drop Stored Procedure activity from Activities → Others → Stored Procedure under Repository View. See the below screenshot
- 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.
You may be interested in...