David-

Just to continue thinking out loud...it occurs to me that I can simply grab a lock on the serial number record when I start a transaction, and, if the transaction is cancelled, just release the lock. Otherwise, I'll delete the record. That way I won't throw any numbers away.

Thanks again.