Uray,
I remember commenting on this type of situation against Oracle 8i a couple of months ago? Or maybe more recently. Anyway the issue is "generally" the same in Java/Oracle comment from before.
It looks like you are looking for a repeatable number sequence in your application? If...