1. User's Guide
  2. SQL Server Gateway Features and Restriction

2 SQL Server Gateway Features and Restriction

After the gateway is installed and configured, you can use the gateway to access SQL Server data, pass SQL Server commands from applications to the SQL Server database, perform distributed queries, and copy data.

  • Remote Insert Rowsource
    A remote insert rowsource feature allows remote insert requiring local Oracle data to work through the Oracle database and Oracle Database Gateway. This functionality requires that the Oracle database and the Oracle Database Gateway to be version 12.2 or later.
  • Using the Pass-Through Feature
    The gateway can pass SQL Server commands or statements from the application to the SQL Server database using the DBMS_HS_PASSTHROUGH package.
  • Executing Stored Procedures and Functions
    Using the procedural feature, the gateway can execute stored procedures that are defined in the SQL Server database.
  • CHAR Semantics
    This feature allows the gateway to optionally run in CHAR Semantics mode.
  • Multi-byte Character Sets Ratio Suppression
    This feature optionally suppresses the ratio expansion from SQL Server database to Oracle database involving multi-byte character set.
  • IPv6 Support
    Besides full IPv6 support between Oracle databases and the gateway, IPv6 is also supported between this gateway and SQL Server database.
  • Gateway Session IDLE Timeout
    You can optionally choose to terminate long idle gateway sessions automatically with the gateway parameter HS_IDLE_TIMEOUT.
  • Remote User-defined Function Support
    User-defined functions in a remote non-Oracle database can be used in SQL statements.
  • Database Compatibility Issues for SQL Server
    SQL Server and Oracle databases function differently in some areas, causing compatibility problems.
  • Known Restrictions
    These topics describe known restrictions in Oracle Database Gateway for SQL Server and includes suggestions for dealing with them when possible.
  • Known Problems
    These topics describe known problems with Oracle Database Gateway for SQL Server and includes suggestions for correcting them when possible.