2 Sybase Gateway Features and Restrictions

After the gateway is installed and configured, you can use the gateway to access Sybase data, pass Sybase commands from applications to the Sybase 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 Sybase commands or statements from the application to the Sybase 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 Sybase database. It is not necessary to relink the gateway or define the procedure to the gateway, but the procedure's access privileges must permit access by the gateway.
• 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 Sybase 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 Sybase database.
• Gateway Session IDLE Timeout
  You can optionally choose to terminate long idle gateway sessions automatically with the gateway parameter HS_IDLE_TIMEOUT.
• Database Compatibility Issues for Sybase
  Sybase and Oracle databases function differently in some areas, causing compatibility problems.
• Known Restrictions
  The following sections describe the known restrictions and includes suggestions for dealing with them when possible.
• Known Problems
  This section describes known problems and includes suggestions for correcting them when possible for Oracle Database Gateway for Sybase.