Procedural Replication with Streams
(Doc ID 1079554.1)
Last updated on SEPTEMBER 03, 2021
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform.
Goal
This is a complete example of simulating Procedure replication using Streams.
PROCEDURE REPLICATION
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.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
