This is a text description of Figure 9-3, "Calling Oracle Stored Procedures in a Distributed Oracle Environment".

The functions illustrated in the figure are described in the surrounding text, section "Using Oracle Stored Procedures with the Gateway".

In the figure, an Oracle application is calling the two Oracle stored procedures through two separate Oracle9i instances (ORA1 and ORA2) of the Oracle9i database.

Procedure oraproc1, which is stored in instance ORA1, includes a statement that accesses a table in the ORA2 instance.

In this same manner, Oracle stored procedures can be used to access DB2 tables through the gateway.