Problem using sequence in oracle stage.
Posted: Fri Jun 16, 2006 9:53 am
Hi,
I have two jobs that insert data into the same table in oracle database. We have a field in this table that gets its value from a sequence created in Oracle. I first run one job to insert into the table and next the other. But the sequence number does not continue from the last value that was present after the completion of the first job. Instead the sequence is automatically rounded off to the next nearest hundredth place. (ie if the sequence value was 1200105 at the end of the first job, the starting sequence for the next job is 1200200.) I use the SEQUENCE.NEXTVAL in the insert statement in the oracle stage. what could be the problem?
Thanks and regards.
Aravind
I have two jobs that insert data into the same table in oracle database. We have a field in this table that gets its value from a sequence created in Oracle. I first run one job to insert into the table and next the other. But the sequence number does not continue from the last value that was present after the completion of the first job. Instead the sequence is automatically rounded off to the next nearest hundredth place. (ie if the sequence value was 1200105 at the end of the first job, the starting sequence for the next job is 1200200.) I use the SEQUENCE.NEXTVAL in the insert statement in the oracle stage. what could be the problem?
Thanks and regards.
Aravind