Posted: Thu Oct 29, 2009 7:04 am
1. If database connection fails due to some reason and the rows cannot be inserted in TB_01
The job gets aborted. You have to catch the status of the job.
And think about a restartable sequencer
2. If the table gets locked and the rows cannot be inserted in TB_01
Same thing, think about restartable sequence.
imo, your thinking musn't be at line level (line inserted or not) but at job level (job finished or not)
If you doesn't want lock, execute a script before the job to stop request that may cause locks on the table.
The job gets aborted. You have to catch the status of the job.
And think about a restartable sequencer
2. If the table gets locked and the rows cannot be inserted in TB_01
Same thing, think about restartable sequence.
imo, your thinking musn't be at line level (line inserted or not) but at job level (job finished or not)
If you doesn't want lock, execute a script before the job to stop request that may cause locks on the table.