Multiple Stored Procedures - One at a time

[Former Member]

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

[Former Member]

Hi Ricardo,

According to my knowledge not required to use the BPM.

In that first stored procedure you can call the another stored procedure, internally database can take the all necessary actions.

Check this links

http://www.sommarskog.se/share_data.html

http://bytes.com/topic/sql-server/answers/79780-stored-procedure-calling-another-stored-procedure_

Regards

Ramesh