Kbase P13076: Support and limitations of sequences in Oracle dataserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2004 |
|
Status: Verified
GOAL:
Support and limitations of sequences in Oracle dataserver
GOAL:
What is a sequence generator?
GOAL:
Does Oracle data server support Oracle's sequence generator?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Oracle DataServer
FIX:
A sequence generator is a database object that provides incremental values within any integer range. You can specify any positive or negative increment. The DataServer supports the ORACLE sequence generator. If you add a sequence to a table in your supporting ORACLE database, you must update the schema image to reflect this addition.
However there are certain limitations in supporting these sequences:
1. Do not define ORACLE sequences with names ending in _SEQ unless the dataserver manual instructs you to do so. The DataServer uses ORACLE sequences whose names end in _SEQ for internal purposes.
2. There are two Progress 4GL functions that provide information about database sequences, NEXT-VALUE and CURRENT-VALUE. When you use the DataServer, you can use these functions to get information about sequences in your ORACLE database, but you must use the NEXT-VALUE function first in the same session you use the CURRENT-VALUE function.