This is a text description of Figure 9-2, "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 two Oracle stored procedures (oraproc1 and oraproc2) from an Oracle server instance.

In the figure, the Oracle application is calling the two Oracle stored procedures through two separate Oracle server instances of the Oracle Database (the instances are ORA1 and ORA2).

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

Synonyms are created to maintain location transparency. By using a synonym, the application no longer needs to use the database link specification to start the stored procedure at the remote Oracle instance.

In this same manner, synonyms can be created for non-Oracle database instances, which are accessed through the Oracle Transparent Gateway for iWay and an iWay Server. Using synonyms, Oracle stored procedures can be used to access non-Oracle database data through a gateway instance and an iWay Server.