SV: Sequence

I think you have to give a little more information on how you are usign the sequence. But I will give you some ideas what can give such a problem. When you are using sequences you have to bee careful on how many rows that the sequence is affecting. For examle:

Select samlepseq.nextval from dual;

This will increment the sequence by one if the sequence is desinged to do so and that the table dual only contains one row!

Select sampleseq.nextval from table_containg_ten_rows;

This example will increment sampleseq by 10 since the select command returns 10 rows;

So look in your procedure and see how many rows is affected in your use of the sequence.

Tomas,

--
Standard applications on Oracle databases
www.digimera.com