Skip to Content
0
Former Member
Dec 09, 2009 at 01:52 PM

Multiple Stored Procedures - One at a time

106 Views

Hello everyone!

I´m going to start an interface that requires me to call multiple Stored Procedures, but they will not be called at the same time.

The legacy system has 3 stored procedures to be called, like this:

1 - SP number 1: it says to the legacy system that some data is going to come up and clean the previous data

2 - SP number 2: input data into the legacy system

3 - SP number 3: for each line above, more lines will be inserted - sort of header/line cenario

My question is: should I be able to achieve this goal using only PI 'normal' components or will I have to use BPM?

Thanks!

Ricardo Sancio Lóra

Brazil