2.2 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.
Use the DBMS_HS_PASSTHROUGH
package in a PL/SQL block to specify the statement to be passed to the Sybase database, as follows:
DECLARE
num_rows INTEGER;
BEGIN
num_rows := DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@SYBS('command');
END;
/
Where command cannot be one of the following:
-
BEGIN TRANSACTION
-
COMMIT
-
ROLLBACK
-
SAVE
-
SHUTDOWN
-
Sybase tool commands
The DBMS_HS_PASSTHROUGH
package supports passing bind values and executing SELECT
statements.
Note:
TRUNCATE
cannot be used in a pass-through statement.
See Also:
Oracle Database PL/SQL Packages and Types Reference and Chapter 3, Features of Oracle Database Gateways, of Oracle Database Heterogeneous Connectivity User's Guide for more information about theDBMS_HS_PASSTHROUGH
package.
Parent topic: Sybase Gateway Features and Restrictions