The following table compares the features of the OpenEdge and Oracle sequence generators. An application that relies on sequence generators can access an OpenEdge database and, through the DataServer, an Oracle database. See the chapter on database access in OpenEdge Getting Started: ABL Essentials for information on defining and using OpenEdge sequences in your database applications.

If you add a sequence to a table in your supporting Oracle database, you must update the schema image to reflect this addition. See The DataServerTutorial for instructions on updating a schema image.

There are two ABL 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.