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

The functions illustrated in the figure are described in the surrounding text.

The figure shows an Oracle application calling an Oracle stored procedure (empproc) from an Oracle server instance.

The Oracle application (by using the Oracle empproc Focus Procedure) is updating a table. The table is located in a VSAM IMS Database, which is being accessed by the Oracle server through an Oracle Transparent Gateway for iWay and an iWay Server.

The purpose of this illustration is to show that an Oracle stored procedure (which is located in an Oracle Database instance) can access data in the iWay Server by using the Oracle Transparent Gateway for iWay.

Compare this figure with figure 9-4, in which the Oracle stored procedure is located in an iWay Server.