I have a job to insert records into a target table with oracle sequence.next val value for the primary key. The oracle sequence is cyclic, and if i get the primary constraint violation for few number of records(ex 50 records out of 1 million), then i dont want to abort the job, rather i want to run the job for 1mil-50 records..
how can i do that.
also apart fromd atastage log, how can i capture the records which got errored out?
primary key constraint to be considered as a warning
Moderators: chulett, rschirm, roy