Procedural Replication with Streams
(Doc ID 1079554.1)
Last updated on JANUARY 30, 2019
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Information in this document applies to any platform.
This is a complete example of simulating Procedure replication using Streams.
The ability to replicate the invocation or call of a pl/sql procedure to another database, rather than the actual DML changes the procedure performed, is known as procedural replication. This page describes a method of accomplishing procedural replication in a Streams environment. Procedural replication is simulated in Streams by creating a PL/SQL wrapper procedure and identifying the procedure to be run in an anonymous block. The wrapper procedure performs the user procedure to be replicated and generates a DDL statement that will execute the procedure at the target database. The DDL statement is replicated to the target database rather than the DML generated by the user procedure. This technique is most useful for performing large batch updates in Streams using stored procedures.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!