Re: Reseting a sequence number to value less than current last_number

Originally posted by James Williams
> I have a bunch of sequnce numbers to reset. I would rather not drop
> and recreate them to have to do grants and recompiles.
>
> I am trying to get the below program that I wrote to work. Maybe
> someone can enlighten me on my flaw. The last number never changes.
>
> Forgive the spaghetti code!
>

Forgive it? I can't even follow it ;)

Tom Kyte has a solution in 17 lines of code rather than 300:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:95- 1269671592

I think it works the same way as yours in essence.

--
Posted via http://dbforums.com