establishing commit-rollback mechanism in a transaction

[Former Member]

Hi,

If there are more than one tables that records to be inserted into and more then one record for some tables, is it possible to establish commit rollback mechanism?

It must be used repeater action for some tables because of more than one records to be inserted.

I'm trying to establish commit rollback mechanism for all inserts for oracle database.

Is it possible?

Thanks.

[Former Member · Accepted solution]

Hi,

with the standard SQLQuery it is not possible. Sam has develop some custom action blocks with this

functionality. Take a look on this link [Installing the SAP MII v12.1 JTA JDBC Custom Action Blocks.|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/10bfa608-103b-2c10-6399-e41044c3363e]

BR

Pedro

[jcgood25]

Another option to consider would be to do this work on the Oracle side in a function or procedure, where it handles the session and simply gets fed with the details by MII.