Hi again,
Were working on a Job Control with different jobs doing
updates and/or inserts on an Oracle Database. If a job
aborts we would like to have a rollback made immediately in
order to facilitate life for or production team.
We havent been able to find out how to do this yet, so I
was thinking that maybe one (or several) of You guys have
encountered this kind of thing before?!
Thanks in advance for any ideas!
Per
Automatic Rollback
Set the transaction size on your OCI to 0 and then it will automatically
rollback if it aborts..
At 04:44 PM 6/6/01 +0000, you wrote:
>Hi again,
>
>Were working on a Job Control with different jobs doing updates and/or
>inserts on an Oracle Database. If a job aborts we would like to have a
>rollback made immediately in order to facilitate life for or production
>team.
>
>We havent been able to find out how to do this yet, so I
>was thinking that maybe one (or several) of You guys have encountered
>this kind of thing before?!
>
>Thanks in advance for any ideas!
>
>Per
rollback if it aborts..
At 04:44 PM 6/6/01 +0000, you wrote:
>Hi again,
>
>Were working on a Job Control with different jobs doing updates and/or
>inserts on an Oracle Database. If a job aborts we would like to have a
>rollback made immediately in order to facilitate life for or production
>team.
>
>We havent been able to find out how to do this yet, so I
>was thinking that maybe one (or several) of You guys have encountered
>this kind of thing before?!
>
>Thanks in advance for any ideas!
>
>Per