Not finding Transaction rollback option in Oracle connector

adasgupta123 · Post by **adasgupta123** » Thu Jan 12, 2012 6:22 am

Hi ,

In my job I am inserting some records to a oracle table using Oracle connector stage.Requirement is that either all records are inserted successfully or the the entire transaction is rolled back.For example : I have 4 records to insert ,one of them violates unique constrain.In this case the entire transaction should be rolled back and even the other 3 records should not be inserted.Even if the job aborts due to same non oracle error(like force full killing of the job ),the entire transaction should be rolled back.

Is there any way to implement this through Oracle connector stage?

Thanks and Regards

Avik Dasgupta

nagarjuna · Post by **nagarjuna** » Thu Jan 12, 2012 7:04 am

There is an env variable APT_ORA_COMMIT_ROWS through which we can control this ..It is applicable for enterprise stage ..I am not so sure for connector stage