stored procedure

[Former Member]

Hello, i hope you´re pretty good, i have a problem and i´ll be really thankful if you can help me.

I have just begin with SAP PI and I need to run a stored procedure, which is made of one input and two output parameters, A and B. the first one receives as argument a character string, if it meets with the requirements, it delivers a numerical code for A and descriptive text of the code for B.

It is necessary SAP PI ejecute commit if code that returns A is the same to 0 (0 -> Ok, -> Commit), otherwise ejecutarce rollback will be execute (

<param1 type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

Although I don´t know what should I use to implement commit and roolback

As I said before, i´ll be very thankful of your recommendations.

[Former Member]

You can do a JDBC lookup to the target. Once your criteria satisfies then you can push data to JDBC otherwise stop the mapping.

Regards

Raj

[VijayKonam]

This is not a straight forward requirement. You might have to use BPM for this scenario or, better put the whole logic with SP and just call it from PI.

VJ