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 theDBMS_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 inCHAR
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 parameterHS_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.