Subject Sequential running no using trigger and generator
Author junior

I need a continuos running number to be inserted into a field, but every time when there is any exception during posting, the generator will get incremented, so my current thought is:

1. Create 2 generators, 1 to be called before insert, another to be called after insert.

2. Create 1 generator, insert 0 or -1 or any arbitrary no into the field, then call the generator to get the number.

Which way is better, any unwanted side effects? Or is there better ideas?

Thanks in advance.

Best wishes,

[Non-text portions of this message have been removed]