Kbase P98018: Does the Oracle DataServer support re-assigning the CURRENT-VALUE of a sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/01/2006 |
|
Status: Verified
GOAL:
Does the Oracle DataServer support re-assigning the CURRENT-VALUE of a sequence
GOAL:
Can a sequence be reset by assigning the CURRENT-VALUE when using the Oracle DataServer.
GOAL:
How can I reset the CURRENT-VALUE of a sequence
FACT(s) (Environment):
Oracle DataServer
FIX:
The Oracle DataServer does not support resetting the CURRENT-VALUE of a sequence. The only 4GL functionality which is supported for the CURRENT-VALUE is to read the value.
To reset the CURRENT-VALUE of a sequence within Oracle, you must drop the sequence and recreate with an initial value set to what you want the CURRENT-VALUE to be.