Not finding Transaction rollback option in Oracle connector
Posted: 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
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