Specifying How Replication Server Replicates Stored Procedures

Add a new section to “Replicate database connectivity for Oracle” in Chapter 10, “Oracle Replicate Data Server.”

If you use ExpressConnect for Oracle, set dsi_proc_as_rpc on. ECO only supports stored procedure replication using remote procedure calls. By default, Replication Server sets dsi_proc_as_rpc on if you use one of the Oracle ECO connection profiles when you create the connection to the Oracle database from Replication Server. See Replication Server Options 15.5 > Installation and Configuration Guide ExpressConnect for Oracle 15.5 > Configuring ExpressConnect for Oracle.

If you use ECDA Option for Oracle, set dsi_proc_as_rpc off. ECDA does not support remote procedure calls for stored procedure replication.