Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Arrays


The DataServer supports arrays, which are also called field extents. When you create a schema image for an Oracle database, OpenEdge interprets a number of specially named Oracle columns of the same data type as a single OpenEdge field with the same number of extents. You name the Oracle columns column-name##1, column-name ##2, etc. A single field definition is created in the schema image for the field extent.
When you use the OpenEdge DB-to-Oracle migration utility, OpenEdge automatically modifies Oracle data definitions to support arrays. For example, if your OpenEdge database has an array named MONTH with 12 elements, the utility creates 12 columns named MONTH##1, MONTH##2, etc. in the Oracle table.