You are here: FME Readers and Writers > Oracle Non-Spatial Reader/Writer > Feature Representation

Feature Representation

Features read from Oracle databases consist of a series of attribute values. They have no geometry. The feature type of each Database feature is as defined on its DEF line.

Features written to the database have the destination table as their feature type, and attributes as defined by on the DEF line.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Attributes), the Oracle Non-Spatial module makes use of the following special attribute names:

Attribute Name

Contents

oracle_type

The type of geometric entity stored within the feature. This is always set to:

oracle_nil

Features read from, or written to, Oracle databases have an attribute for each column in the database table. The feature attribute name will be the same as the source or destination column name. The attribute and column names are case-sensitive.