Case 6: The Pass-Through Feature

Demonstration of the pass-through feature using the UPDATE statement with bind variables and using the SELECT statement.

Case 6 demonstrates the gateway pass-through feature which allows an application to send commands or statements to SQL Server.

UPDATE Statement

Demonstration using the pass-through feature and UPDATE statement.

Case 6a provides an example of a pass-through UPDATE statement with bind variables. In this example, the salary for EMPNO 7934 is set to 4000.

SELECT Statement

Demonstration using the pass-through feature and SELECT statement.

Case 6b provides an example of a pass-through SELECT statement. The data that is returned from the SELECT statement is inserted into a local table at the Oracle database.