3 Features of Oracle Database Gateways

This chapter describes the major features provided by Oracle Database gateways. Descriptions of these features are in the following topics:

• SQL and PL/SQL Support

• Heterogeneous Replication

• Passthrough SQL

• Result Set Support

• Data Dictionary Translations

• Date-Time Data Types

• Two-Phase Commit Protocol

• Piecewise LONG Data Type

• SQL*Plus DESCRIBE Command

• Constraints on SQL in a Distributed Environment

• Oracle's Optimizer and Heterogeneous Services

  Note:

  These features may not be available in all Heterogeneous Services gateways. Not only must there be generic support for these features, which Heterogeneous Services provides, but there must also be support added to the driver for them. Consult the appropriate gateway documentation to determine if a particular feature is supported for your gateway.