The Oracle Spatial Relational Reader/Writer module provides the Feature Manipulation Engine (FME) with the ability to read and write geometric and attribute data stored using Oracle Spatial. This module communicates directly with Oracle Spatial for maximum throughput. Both the relational and object-relational models of Oracle Spatial are supported by FME: the relational model is discussed here and the object-relational model is discussed in a separate chapter – Oracle Spatial Object Reader/Writer.

If only attributes are to be read or written, then the Database reader and writer module of FME should be used. In addition, an OracleQueryFactory is available to extract data from an Oracle Spatial database within the FME factory pipeline. This chapter assumes familiarity with Oracle Spatial, the geometry types it supports, and its indexing mechanisms.

Tip:
See the QueryFactory in the FME Functions and Factories manual. This factory also exploits the powerful query capabilities of Oracle Spatial. See the @SQL function, also in the FME Functions and Factories manual. This function allows arbitrary Structured Query Language (SQL) statements to be executed against any Oracle database.

Download