Skip to Content
avatar image
Former Member

Multiple Stored Procedures - One at a time

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 09, 2009 at 07:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded