Oracle Commit...

kamalraaj · Post by **kamalraaj** » Thu Jan 30, 2003 1:27 am

Hi All,

I am using stage constraint and abort rows as 1. When I run the job it stops immd when it violates the constraint but also it commits all the records till it processed. I don't want that to happen. Any chance of getting rollback in this if one record violates the constraint.

I am using oracle database. and the Rows per transactions is set to 0.

Kamal

uneumann · Post by **uneumann** » Thu Jan 30, 2003 3:19 am

Did you enable transaction grouping in your OCI Stage?

kamalraaj · Post by **kamalraaj** » Thu Jan 30, 2003 3:53 am

Hi Uneumann,

Iam Using 5.2 and Row per Transactions is set to '0'. I did't get what you are mention about Transaction Grouping, Kindly clear this.
Thanks,

Kamal

ray.wurlod · Post by **ray.wurlod** » Thu Jan 30, 2003 4:07 pm

Transaction grouping is only relevant where there is more than one input link into the stage driving Oracle.